showing cell value in a UserForm

[MistyLogic]

How do I show a cell's value on a UserForm? With a Control? If so which one?

 

[Smitty]

Like so:

TextBox1.Value = Sheets("Sheet1").Range("A1")

HTH,

Smitty

 

[MistyLogic]

Umm, where? In the code for the UserForm or for the TextBox? I've tried both to no avail.

 

[QuietRiot]

Sub Macro1()

UserForm1.TextBox1.Value = Cells(1, 1).Value
UserForm1.Show

End Sub

like that..

 

[Smitty]

Umm, where? In the code for the UserForm or for the TextBox? I've tried both to no avail.

It could be anywhere depending on what you're trying to do. If you're trying to add items at runtime, try the UserForm_Initialize() event.

Smitty