I used an "add" button to put all the value entered in the text box
into a certain cell on the spreadsheet when executed.

Dave Peterson wrote:
But it does have a .ControlSource property.

EA wrote:

A text box does not have a linked cell, which I think you are thinking
about.

A decent question would be why would you want a user to enter text into a
text box which would then be transferred to a cell. Why not just have the
user enter the text directly into the 'target' cell?

"Astello" wrote in message
oups.com...
This is probably a stupid question, but in the properties window for a
textbox, how do you designate the cell that you want the data entered
into the textbox to go to?


--

Dave Peterson