Textbox to look at a cell in spreadsheet

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

I want a to have a textbox set up in one of my userforms
to tell me what the value of cell aa10 is. I need this to
determine if I want to continue with the some other
options or stop.

Can anyone tell me how to achevie this?
Sammy
 
Sammy,

Put this in the UserForm_Activate event.

Textbox1.Text = Range("AA10").Value

HTH
Henry
 
Back
Top