userforms
 

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

userforms
 

hi
JobBoxox1.Value = Range("A1").Value

regards
FSt1

"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

userforms
 

Would it help to put that in the Initialize Event of the UserForm?
Right click the user form in design mode and click on the declarations box
at the upper right of the code window. Then from the drop down menu, click
initialize and put FSt1's code between the lines. Then when you run your
show command, the text box will load with the range value displayed.

"FSt1" wrote:

hi
JobBoxox1.Value = Range("A1").Value

regards
FSt1

"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