I'm trying to learn a little about userforms
I have a simple user form with one textbox


This is the macro that open the form

Sub form()

frmUserform.Show

End Sub



There is one text box on the form called JobBox1


How do i get the form to open and put the value of cell A1 one in the
text box.



Thanks

Hello Again. I glad to see your taking my advise and learning how to use the
userform. You need to add the items before you open the box. when you type
frmuserform. VBA will automatically show you the list of methiods and the
textbox1 will be one of these methods if you already created the userorm and
textbox.

Sub form()

frmuserform.textbox1.text = "My String"
frmUserform.Show

End Sub


"Little Penny" wrote:

I'm trying to learn a little about userforms
I have a simple user form with one textbox


This is the macro that open the form

Sub form()

frmUserform.Show

End Sub



There is one text box on the form called JobBox1


How do i get the form to open and put the value of cell A1 one in the
text box.



Thanks