Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Place a list box in a cell
On Apr 12, 1:25 am, "Hank Youngerman" wrote:
I know how to put a control on a page, and pass the values in that control to a module. What I want to do is simply put a list box or combo box in a cell, so that the user, instead of typing a value in the cell, clicks on the drop-down arrow. The value is then placed in that cell and used by the spreadsheet like it would any other cell. Data Validation. Allow = List The List can be a range of cells on that sheet or a Named Range in the workbook or just a comma separated list. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help! Dates gone and list of number in it's place | Excel Discussion (Misc queries) | |||
extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
Filter list in place if a cell has a keyword within a formula | Excel Programming | |||
How can I place a condition on a list? | Excel Discussion (Misc queries) | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |