| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
in-cell on-the-fly list/combo box
I am not sure how to express this and thus have had no luck searching if it
has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in-cell on-the-fly list/combo box
Look for help on: Data Validation.
Good Luck. "DoctorG" wrote: I am not sure how to express this and thus have had no luck searching if it has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in-cell on-the-fly list/combo box
Thanks ND Pard. I looked up "Data Validation" in Help and the following code
did the trick. With ActiveCell.Validation .Delete .Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange" .InCellDropdown = True End With "ND Pard" wrote: Look for help on: Data Validation. Good Luck. "DoctorG" wrote: I am not sure how to express this and thus have had no luck searching if it has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in-cell on-the-fly list/combo box
Just so you are aware... you can do that from the menu bar as well (click
Data/Validation and fill-in the dialog box). -- Rick (MVP - Excel) "DoctorG" wrote in message ... Thanks ND Pard. I looked up "Data Validation" in Help and the following code did the trick. With ActiveCell.Validation .Delete .Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange" .InCellDropdown = True End With "ND Pard" wrote: Look for help on: Data Validation. Good Luck. "DoctorG" wrote: I am not sure how to express this and thus have had no luck searching if it has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in-cell on-the-fly list/combo box
Weeeellllllll...... it was kinda easier than I thought......
Ok, Rick, point well taken : learn the basics, then move on. Nevertheless I "touched" things I wouldn't have otherwise. Thanks a lot, both of you !!!!! Now what about the next question concerning Worksheet_Change after the validation? "Rick Rothstein" wrote: Just so you are aware... you can do that from the menu bar as well (click Data/Validation and fill-in the dialog box). -- Rick (MVP - Excel) "DoctorG" wrote in message ... Thanks ND Pard. I looked up "Data Validation" in Help and the following code did the trick. With ActiveCell.Validation .Delete .Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange" .InCellDropdown = True End With "ND Pard" wrote: Look for help on: Data Validation. Good Luck. "DoctorG" wrote: I am not sure how to express this and thus have had no luck searching if it has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in-cell on-the-fly list/combo box
I don't see an earlier question from you regarding Worksheet_Change and your
brief mention of it is not enough to figure out what your actual need is related to it... can you provide more detail please? -- Rick (MVP - Excel) "DoctorG" wrote in message ... Weeeellllllll...... it was kinda easier than I thought...... Ok, Rick, point well taken : learn the basics, then move on. Nevertheless I "touched" things I wouldn't have otherwise. Thanks a lot, both of you !!!!! Now what about the next question concerning Worksheet_Change after the validation? "Rick Rothstein" wrote: Just so you are aware... you can do that from the menu bar as well (click Data/Validation and fill-in the dialog box). -- Rick (MVP - Excel) "DoctorG" wrote in message ... Thanks ND Pard. I looked up "Data Validation" in Help and the following code did the trick. With ActiveCell.Validation .Delete .Add xlValidateList, xlValidAlertStop, xlBetween, "=ValuesRange" .InCellDropdown = True End With "ND Pard" wrote: Look for help on: Data Validation. Good Luck. "DoctorG" wrote: I am not sure how to express this and thus have had no luck searching if it has been asked before. I have seen spreadsheets where, upon entering a cell which "accepts" certain input (Yes/No, True/False etc), a list or combo box is "created" on the fly within the cell and restricts input to the predefined values. Can anyone explain how it is done or where I can find information? Thanks for bearing with me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| validation list or combo box dependant on cell value | Excel Worksheet Functions | |||
| How to reference cell created from dropdown list in a combo box? | Excel Discussion (Misc queries) | |||
| drop-down list(or combo-box) for the cell | Excel Discussion (Misc queries) | |||
| Can I have automatic cell population while using combo list? | Excel Discussion (Misc queries) | |||
| List Box or combo box into a cell | Excel Programming | |||
Hybrid Mode
