Excel VBA USERFORMS #20 Data Entry a Breeze with Userforms! AUTOCOMPLETE with Combobox

excelente trabajo profesor

How if 3 text box, ita same way, how if label. value, its same way?

I still can’t figure out how to make the text box default to date.

Hi. Thanks for the NYC vid. Sir how can we attach two text box lists to each other for controlling wrong data feeding . Linking two lists of data.

If I may, I can only suggest that you can reference the list for combobox just by typing the name of a Named Range you've created into combobox properties, search for option called: RowSource. Thanks to that you can skip the bit of code responsible for building up the list of items for combobox while initializing UserForm. You'll get the same AutoComplete effect.
I love your work by the way.

Thanks in a million. Great content. Awesome imagination.Grade: A++💥

Bro I try to do your steps and now I am on the submit button.. I wrote the code but when I run it I fill the info and then when I click submit it does not run it and say run time error 9. Subscript out of range. What should I do my man?

I have a question. Why i cannot run the code. It shows run-time error ‘424’ object required

nice. I like it.

Thankes for it

helpful

blah was not defined

bro your video are more simple and straight to point . good job man

thanks nice video. please what is a the code if i want to enter the date into sheet 2, 3 and 4 using different user form

Using "each blah" for this formula is making this confusing and "ssheet" was the even necessary? Are you trying to show off or actually teach people VBA? Super annoying.

HOW TO ADD PICTURE FROM USERFORM TO EXCEL CELL INFRONT OF NAME CELL

Where's the tutorial about the list you said on the video?

Hi i need help in creating a data entry form with macros. when i enter reference number in part no start time should automatically come and when i click end it should end. can you help

VERY BEAUTIFUL ... IF YOU MAKE FILES LIKE THIS VIDEO VIDEO AND SHARE WILL BE GREAT. STAY WITH LOVE

@

Hello friend and thank you for this video, I am having an error when trying to run part of this code, more specifically with the submit button, the error I get says "Wrong number of arguments or invalid property assignment" I´m not sure what´s going on, I hope you can shed some light over here...

Hello and thank you, i would like ask you: with combox1 It is possible make the a opposite as in this video so, choose the text in cells and full the combox?

I'm looking for Excel 365 for Mac advanced short cut keys instead of you PC Alt + I + D (dynamic name range)

thank u

hey, I am having some problems with my code. can you tell me what i am doing wrong here? Debugging shows the issue in the nr = line with either maxed out rows even though there is no data in the worksheet or it says cdate(me.tbdate) is the issue

Private Sub btnsubmit_Click()

Dim newcert As Worksheet

Set newcert = ThisWorkbook.Sheets("certifications")

nr = ThisWorkbook.Sheets("certifications").Cells(Rows.Count, 1).End(x1up).Row + 1

newcert.Cells(nr, 1) = Me.tbname
newcert.Cells(nr, 2) = Me.tbID
newcert.Cells(nr, 3) = Me.CBpos
newcert.Cells(nr, 4) = Me.CBstat
newcert.Cells(nr, 6) = Me.CBcourse
newcert.Cells(nr, 7) = CDate(Me.tbdate)



End Sub

Private Sub UserForm_Initialize()
Me.tbdate = Date

For Each Position In [Table10]
Me.CBpos.AddItem Position

Next Position

For Each Status In [table11]
Me.CBstat.AddItem Status

Next Status

For Each course In [table12]
Me.CBcourse.AddItem course

Next course

End Sub

Sir. The
nr=ssheet.cells(rows.count,1).end(x1up).row+1
Not working. It keep prompted yellow.

Can you please check this for me ? getting error message at Blah- says variable not defined

Private Sub UserForm_Initialize()

Me.Texdate = Date

'fill combobox
For Each blah In [Nature_of_Contact]
Me.Combonat.AddItem blah

'fill listbox
For Each blah In [phone]
Me.Listphone.AddItem blah

'fill combobox
For Each blah In [Visit]
Me.Comboreason.AddItem blah

Next blah

End Sub

says variable has not been defined

My List is on another spreadsheet because I have a lot of data that I want to sort through and if I have my userform on the "list" sheet it would be too chaotic. This video got me half of the way, now I need to find how to "link" my List to the userform that's on another sheet. Thanks for your help boss! My search continues. :o)

🚈🚝看美眉露点私禁🚫视频➕微信hot5383🚘🚡衣冠楚楚尺寸🇫🇷🇫🇷f g g h h

Superb.. Its giving auto date and time in the userform in the simple one line me.tbdate = date & "" & time

works perfect.

Hello
Thank you for the great video!
I'm getting an error saying "Type Mismatch".
I don't know where the problem lies.
Any help is appreciated!
Thank you!
SK

how to add search button thanks

Is it possible to write a code in vba to make a certain excel file not open after 200 hours. As soon as the excel is open or minimized, the minutes or hours should count down. The data entered in this excel shall not be able to copy into other excel file or viceversa. Later when the hours become 0 then the excel shall be locked and ask username password for login. Later the operator shall get new login details from me for him to login to his excel. The operator shall not be able to see vbn code nor edit it. I would appreciate any help on this

Hi I have one doubt whenever we enter the data in userform how to convert that data in directly xml format file without excel sheet
Thanks in advance

Really helpful this

Good video but remember to explain the keyboard shortcuts as your doing them out of view. F5 got me into the form but had to search all over to find Alt + F4 closes it and takes back to design mode.

you are a genius guy

Clear, right speed, simple example explanation, thanks! Although, in my example I run into a bug at the line where we search for the next empty row. "application-defined or object-defined error". I can't solve this...

Hello, thanks for the video and need help to enter date in the form without typing slash symbol. Ex: if i type only the number slash should be default for the date format mm/dd/yyyy. can you please help me

Good pace on this video.

how i can put data in row 14 not in row 1
I have date before 14 first row and after 18 row i need to put de data between. THanks

Run Time Error 424, Object Required

thank you thank you so much plz add me whatsapp 03223016081

Thanks this is so helpful...

Can anyone help me . I have combo box and text box for data entry. Is there any way when i select item listed on combo box and enter anything on textbox would go to the sheet where i want to put. But combo box will only find the item on the sheet of what was being selected . Onlythe text will be entered once selected item found

Hey mate great video. Just a quick question- For listbox, how would you adapt your code to have multiple selections passed back to a single cell seperated by a comma back in your worksheet.

this video is tha bomb. i mean seriously, i now have a basic grasp of how to use VB and i have a data entry form of drop downs!!!!

Your code did not work for me. Sorry.