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

Please refrain from multiple postings. See your second post.

"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

Sub form()

With frmUserform
.JobBox1.text = ActiveSheet.Range("A1").Text
.Show
End with
End Sub

--
Regards,
Tom Ogilvy


"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