Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform to search by entering data into a textbox | Excel Programming | |||
Userform: Enter combobox value unless textbox contains data | Excel Programming | |||
userform textbox | Excel Worksheet Functions | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Use numeric data from a textbox on an userform | Excel Programming |