Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Comment on the basis of Text Box Entry
Hi
I am building an small interactive questionnaire. I am using Data Validation Lists to get responses for the questions. I have a few questions where on the basis of the choice made, I need to capture some more data. (currently I am thinking this could be a text box though my ideal preference would be for a option button.). What I want to know is if some text is entered in the box, is it possible for me to insert that text as a "Comment" in the same cell? Example: I have a list: A, B, C, D. On selecting C, I want a text box / Option Button list to pop up. I either enter the text (or select radio button). The entered text (or text associated with selected radio button) should be populated as the comment for the cell. This will significantly simplify my questionnaire design. It will also help if you let me know how this would be different if the text can be placed in another Cell (instead of a comment) Any help is greatly appreciated. Best Prasad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows on the basis of cell comment | Excel Discussion (Misc queries) | |||
Populate xlValidateList; Please Comment | Excel Programming | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
Breaking text on the basis of condition | Excel Programming |