Textbox in Userform - data destination
 

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?

Textbox in Userform - data destination
 

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?

Textbox in Userform - data destination
 

I am trying to keep the user from touching the spreadsheet data at all.
I figured it out. Thanks though.

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?

Textbox in Userform - data destination
 

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

Textbox in Userform - data destination
 

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

Textbox in Userform - data destination
 

I like that idea. It would eliminate the possibility of a unwanted change to
the textbox/cell.

But I was responding to EA and his/her comment about the linked cell.

Astello wrote:

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

--

Dave Peterson