hi
i have a userform with a text box in it, but i would like it to display data from a cell in a ws rather than the user typing data in to it, is this possible?
thanks ash
hi
i have a userform with a text box in it, but i would like it to display data from a cell in a ws rather than the user typing data in to it, is this possible?
thanks ash
[vba]
Private Sub Userform_Activate()
Me.TextBox1.Text = Worksheets("Sheet1").Range("A1").Text
End Sub
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
You can also set the controlsource of the textbox to the address of the cell you want. Set the textbox's Locked property to True if you don't want the user changing the contents of the cell.
Reegards,
Rory
thanks very much both of u, good job!