Taking Data of cell from worksheet to a userform window

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

Mete,

As an example to a textbox

Textbox1.Text = Worksheets("Sheet1").Range("A1").Value
 
Userform1.Textbox1.Text = Worksheets("Sheet1").Range("A1").Value

or if you want it formatted as it appears on the screen

Userform1.Textbox1.Text = Worksheets("Sheet1").Range("A1").Text
 
Back
Top