Insert a name to a table via a macro

**uduyt** · 04-25-2012, 01:39 PM

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

**h.maleki** · 04-25-2012, 01:50 PM

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?

**uduyt** · 04-25-2012, 01:58 PM

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

**h.maleki** · 04-25-2012, 06:51 PM

Originally Posted by uduyt

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

After i do that what do i do? Sorry im a beginner with excel. It comes up with an empty box?

Re: Insert a name to a table via a macro