Adding Data to an Excel Worksheet using TextBox Controls on a VBA UserForm

Wow!!! I watch your channel for not excel things and it's fun to see you also created excel videos

Thank you very much, sir.

Very helpful. Thank you.

How to center the address of the user form. When creating a username and password form

Great tutorial its very simple. I did not see any dim's still manage to get what im looking for :) add me up to your subscribers

thank you

Great video

How does that form become a macro? I do all the steps but it isn't on the macro list

Great video! Helped me out a lot with what I was trying to do with my UserForm.

super thanks for this video! helped me fix my problem in vba

Hi Doc, I am working on this data entry worksheet and this video definitely helped me. However, I want to know how to assign the data to a specific cell in the excel worksheet instead of having it pop out to an active cell. This eases the user from having to point to a specific cell before they start loading the data. Thank you

How the executable file created of vba user form and excel sheet ?

thank you for these lessons. it's so interesting, but I have a question. I want to know how did you manage to always have the cell (1,1) active at the start.

This is the best VBA tutorial! TBH, i've been trying to learn this VBA for over a week now and some tutorials are just full of nonsense talking which makes it more difficult. But i have a concern though, hopefully someone can resolve this. I followed everything exactly on the video, but i want my textbox1,2,and 3 to enter data on the columns i need them to be on, not following the Active Cell like used in the video. Any suggestions?

But I need help, My Form is not opening when i assign a macro

Nicely presented and explained. It is clear

How to add a counter for each register? In other colum

Thanks.

very simple and usefull thanks a lot

How to protect the sheet? while the entry form is working.

Short and simple. thanks!

I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a userform in the beginning or the end of the presentation that would allow users to fill and submit the feedback/registrations? Could an embedded Excel w/VBA help with this?

Thank you. how do I put the combo box value directly a specific cell directly? without no offset

Thank you very much sir, kindly share the code bcz the video is not clear. Hope u will respond it.

I have everything working like you showed me to do, But It will not start at the next available row when I enter Data in the form, I have to manually click on the empty row and start my data entry and then it will line up correctly, What di I do wrong?

how about deleting data on data grid?

Can’t see your code. It’s blurry.

Good job Dr.Todd. Thanks for sharing.

How did you get the inputted data to go in the correct cells? Say for example, I want the first first name to go in cell H5.

This was very helpful! Thank you so much! :)

Thanks you for the work you have done here. After entering your prescribed code the UserFprm is great, however it dors not transfer to the spreadsheet. I get an error code "Run-Time error '424':. I do not see how the code knows where the first cell on the spreadsheet. I am sure I have missed something but not sure what it is. Thanks for Your help. Kevin

I want your help very badly please response

Hi how to do the same in c#

Hi Todd, can you help me with one thing I am stuck with, tried many ways but not working. I am writing a userform with a submit button to load data on userform to a spreedsheet. problem is i want excel to choose the next available record number( or row) from the spreedsheet. I tried vlookup, rowX, . please help me out?

I have a quick queation: let's say the user after entering the date he clicked on a cell outside this range, and saved the sheet. The next time the user inputs more data it will be saved outside this range. What I am trying to say is: how to automatically keep the focus on the range of those 3 columns even if the user mistakingly click on a cell in row E and saves?

Thanks

Realy Awsome Teaching

you are great

That's really good one....can u plss give this format I need this for my work

Could you please explain why setting the default value = true enables the user to click the enter button instead of clicking " enter " ?

How would you add additional data to the same name ? Example List of golfers have new scores each week , you want to add John's new score while keeping his previous scores in tact .

Thankyou so much for taking the time to share this Information , it worked great for what I needed .

I've viewed several tutorials on simple userform and I find yours as the one I feel most comfortable with! Thanks for this!

traightforward, thank you Todd

!Wow! easy to follow, and at the same time VERY helpfull codes. Thanks for devoting your time to share with the world.

Dear Would you write us the codes pls

Thanks!

how could be with c#

Hi Dr. Todd, my second input does not go to the next row. It overwrites the first row. Any suggestions?