Excel Textbox On Form To Have Cell Value

[sebhughes]

How can I ahve it so a textbox on ym form will by defualt ahve the cell value of cell A1

 

[Smitty]

You can use the form's initialize event:

Private Sub UserForm_Initialize()
  TextBox1.Value = Range("A1").Value
End Sub

HTH,

Smitty

 

[sebhughes]

DOnt I ahve to say what sheet?

 

[sebhughes]

Nvm I got it working thansk so much

 

[Smitty]

DOnt I ahve to say what sheet?

You can. Without the sheet reference it will refer to the activesheet.

Smitty