Insert a name to a table via a macro

I want to create a macro which will pop up a little window where i can insert a first name and last name, and make those names appear into tables i have created on excel.
How can i do that?

You could create a userform, and add two textboxes with the code:

Private Sub TextBox1_Change()
Range("a1").Value = TextBox1.Text
End Sub

Private Sub TextBox2_Change()
Range("a2").Value = TextBox1.Text
End Sub

Hope that helps

Originally Posted by uduyt

You could create a userform, and add two textboxes with the code:

Private Sub TextBox1_Change()
Range("a1").Value = TextBox1.Text
End Sub

Private Sub TextBox2_Change()
Range("a2").Value = TextBox1.Text
End Sub

Hope that helps

Hey, where do i create a userform from?

from Excel, press Alt-f11 and then when microsoft visual basic opens up, go insert>userform

with the toolbox, make two textboxs(just click on the button with "ab" on it and draw it under where it says userform1) after you've made the two textboxes, double click any of them and a new window should come up with:

Private Sub TextBox1_Change()

End Sub

Delete that and paste the code I showed you before
Then double-click userform1 under forms to the left, and press f5.