drop down menu in vba form

[lezawang]

Hi
I want to create a form which has 2 text boxes for First Name and Last name and one drop down menu which has Year of Birth, so user would enter First, Last and Year of birth and then excel copy that to excel. I know how to do the Text boxes, but not sure if I can do the Drop down menu.
Is it doable? Thank you.

 

[My Aswer Is This]

You said:

I want to create a form ​

Do you mean a UserForm?

You said:

and one drop down menu​

Do you mean Combobox?

You said:

and then excel copy that to excel​

Copy the values in the two textboxes and the Combobox and paste where?

Excel has a lot of places.

 

[lezawang]

Sorry I was not clear. Yes UserForm. Combobox is fine to me if I can select year from it. The UserForm would have "Enter" button. If user pressed Enter then FistName, LastName, Year of birth will go to A1, B1, C1 if row 1 was empty otherwise they will go to A2, B2 and C2.
Thanks

 

[My Aswer Is This]

Assuming you have a Textbox named Textbox1 and Textbox2
These are default names

And a Combobox named Combobox1

And a command button named CommandButton1

Try this:

Put these scripts in your Userform

Private Sub CommandButton1_Click()
'Modified  8/22/2018  12:12:01 PM  EDT
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row + 1
Cells(Lastrow, 1).Value = TextBox1.Value
Cells(Lastrow, 2).Value = TextBox2.Value
Cells(Lastrow, 3).Value = ComboBox1.Value
End Sub
Private Sub UserForm_Initialize()
Dim i As Long
Dim x As Long
x = "2010"
For i = 1 To 15
ComboBox1.AddItem x + i
Next
End Sub

 

[lezawang]

Great! Thank you so so much.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Great! Thank you so so much.