View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Userform with textbox displaying Cell B1 Value

You can load the textbox when the userform is initialezed. Ínsert the
code below in the code sheet for for the userform.

Private Sub UserForm_Initialize()
Me.TextBox1.Value = "Cell B1 is " & Range("B1").Value
End Sub

Regards,
Per


On 4 Okt., 01:04, JMay wrote:
How do I do this?

My Cell B1 contains the number 55.

I want my textbox to read

"Cell B1 is 55",

But HOW???????????