txtbox code

  • Thread starter Thread starter Sal_sal
  • Start date Start date
S

Sal_sal

I have created a form and want to display cell
information from a spreadsheet in a textbox on that form -
any ideas for the VBA code?

Thanks
 
Use the Initialise event of the form :-

Private Sub UserForm_Initialize()
TextBox1.Text = ActiveSheet.Range("A1").Value
End Sub
 
Back
Top