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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Counting TextBox values 1
Access Dateadd function question.. 0
textbox Do nothing 1
locking and unlocking a textbox using command buttons 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Textbox data to cell 5
Set value of all Userform textboxes to "" 4

Back
Top