Відео

can you solve this - have two table in same worksheet i need add data for that two tables by using same Excel.VBA Form

Is there a way that 2 people can work on it at once? Say one person is putting in a new entry and another is searching and editing on the same document/sheet/cell etc

Why did you skip over the security warning? This should all be within Google. Something doesn't seem right with this.

Hi. Thanks for the video. It's very helpful. I have a doubt. I'm using the same in AutoCAD VBA where I'm not using excel to save data. Instead saving it to array variable. I pop up autocad using command button and some operations are performed then userform is showed again. The data is not appearing in list box but is available in the stored variable. How to show the existing data in the list box. please help.

Super helpful 👌

can it work with adding images that are linked as a URL in the sheet? to fill the background or a full screen image?

How do you display more than 10 columns in the list box? Only able to show 9

Why i can only update one data (new data inputed in all the textbox)?

Wonderful video! I saw that I did it the way you did, and it turned out the same. Thank you so much Hay Kel!

You didn't show how the header of each of the 9 columns is placed at the end of the video, we were left with the form without the header of the columns?

Hello, Sir how to add png or gif image....code please🙏

how i want add column detals like you with color green please see in last scene 12:55

Is the Excel file used in the demonstration available for download? I did not see the link.

you are the best thank you

thanks. issue solved

Hi, congratulations for the video. I tried to insert the instructions but on the string "For x" it gives me the error "variable not defined compilation error" how can I resolve it? Thanks in advance

Did you make the script? How did you do that? How to make an appropriate script?

Thanks for the video, hopefully you can help me have a question I also use an ID number linked to the cell this is automatically generated for every new entry on the first sheet . When the ID is processed it is also automatically moved to the second sheet of the (closed ID) the problem is when it is moved I get the same ID number again on my first sheet do you know how I can keep this number unique? Do you have a video of this how I can keep it unique? Thanks in advance

hi this could be very usefel when making an invitation can you make it export 150times with 150 name and address?

perfect!!!

Great job on this tutorial. You earn a like and a sub. BTW i am having trouble on dates using .List. Ex. Me.txtDatePaid.Value = Me.lstDatabase.List(db_Value, 4) When i dbl click data on listbox, a saved value on db ex. 8/6/2024 will display on the textbox as 45565 something

Is there a way we can do it like "copy every 1 hour; if no changes, do not copy"

function createArchiveCopy() { var sheet = SpreadsheetApp.getActiveSpreadsheet(); var sheetName = sheet.getName(); var date = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'yyyy-MM-dd_HH-mm-ss'); var newFileName = sheetName + '_Archive_' + date; // Get the spreadsheet file var file = DriveApp.getFileById(sheet.getId()); // Make a copy file.makeCopy(newFileName); Logger.log('Archive created: ' + newFileName); } Save the Script: Click on the disk icon or File > Save, and give your project a name (e.g., "Archive Script"). Run the Script: Click the play button (▶) to run the script. The first time you run it, you’ll need to authorize the script to access your Google Drive. Check Your Google Drive: The script will create a copy of your Google Sheet in your Google Drive with the name including the current date and time, making it easy to identify when it was archived. You can also set up a time-driven trigger to automatically run this script at regular intervals (daily, weekly, etc.): In the script editor, click on the clock icon on the left sidebar (Triggers). Click + Add Trigger. Select createArchiveCopy from the dropdown menu for “Choose which function to run”. Choose Time-driven for the event source. Set up the type and frequency of the trigger (e.g., daily at a specific time).

Hi! just saw your vid and it helped me a lot. I just have one problem. there are duplicate entries in my form and when I tried to update the latest duplicate entry, the previous entry was the one updating. I don't know the code to fix it.

Really simply and awesome dude, thanks for that simple and direct explanation!

Can this still work on the other users????

You are doing well with your explanation. Do more by explaining each line of code you use in a very simple terms.

Can you get the option selected on an option button added when double clicking the list box line that you want displayed?

Thanks for the great tutorial this has helped me alot!

The save does not work..the search only finds the first record..can you send the gsheet link..thank you in advance for your response.

Is there a copy of the file, please?

Is there a copy of the file, please?

Loved it.. That Really Works

Thank you very much

Super 👍

Great work. I was waiting for such a video like this.thanks a lot

Can i get this file for practice 😊

Hi hay kel show me how to create update bottom witout using userform please it is very important to me

🤦

Hi there, great video and easy to follow. I have a question, how can we add data from the top row, meaning the latest data entry will be in the 1st row while the old data will go down. I would really appreciate if you can assist me. Thanks

Thank you so much❤

my search function is not working 😢

"I loved this tutorial on how to create a Color Picker in App Inventor! 👏 The explanations were clear and detailed, making the process very easy to follow. It's amazing to see how simple it is to add such useful functionality to our app. Thank you for sharing your knowledge ! 🌈"

To whomever are still following this video instructions, the earlier scripts are typed wrong. You have to follow the scripts that are at 4:40 or 5:02

Bro please send both extension files

thank you... i wanted to try but I don't have script editor... what should I do?

I have more than 2lac row data

Hey. I need this source code

Hi

COPY of this SPREADSHEET AVAILABLE...to avoid re-typing. Thanks.