Textbox to look at a cell in spreadsheet
 

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

Textbox to look at a cell in spreadsheet
 

Sammy,

Put this in the UserForm_Activate event.

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

HTH
Henry


"Sammy" wrote in message
...
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