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
|