Text Box Referencing Cell

  • Thread starter Thread starter Markus
  • Start date Start date
M

Markus

WHat VB code do I writ for a control on a sheet in Excel
(Text Box) that will automatically change the text in the
control depending on the value of a cell in another sheet.
If cell a5 on sheet1 = "Vacation" then I want the text box
in sheet2 to equal "Vacation".

Thanks
 
Markus,

You can set the LinkedCell property of the textbox to the cell, and it then
picks it up automatically.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

Naming non-contigent cells with vba 5
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Excel VBA help: Text file formatting 19
Tough one - Cell referencing in Excel/VBA 10
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Array code troubles 4
Text in a Rectangle Object 2
Run two macros for two different sheets 11

Back
Top