| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter values in a column with combo box selections
Hi,
Can some one tell me how to display a combo box with the same list each time the user moves on to the next row in the same column?(like in Access table?) Or is this something that cannot be done with Excel? Thanks in advance Toyfixer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter values in a column with combo box selections
You can probably use the SelectionChange event to call the ComboBox. See VBA
help for info on the event. "ToyFixer" wrote: Hi, Can some one tell me how to display a combo box with the same list each time the user moves on to the next row in the same column?(like in Access table?) Or is this something that cannot be done with Excel? Thanks in advance Toyfixer |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter values in a column with combo box selections
Thanks JLGWhiz.
I got around the problem by using data validation on all the cells in the column. I had to copy the list from the database, with a macro. I think this will be a simple solution. I will try your suggestion, when I have time to do some experimentation. Thank you anyway for the reply. I really appreciate it. Toyfixer. "JLGWhiz" wrote: You can probably use the SelectionChange event to call the ComboBox. See VBA help for info on the event. "ToyFixer" wrote: Hi, Can some one tell me how to display a combo box with the same list each time the user moves on to the next row in the same column?(like in Access table?) Or is this something that cannot be done with Excel? Thanks in advance Toyfixer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Box Showing Date Selections | Excel Discussion (Misc queries) | |||
| Counting Combo Drop Down Box Selections | Excel Worksheet Functions | |||
| Can List or Combo Box have multiple selections? | Excel Worksheet Functions | |||
| How do I enter values in a Combo Box with Excel | Excel Programming | |||
| Multiple Selections in a Combo Box??? | Excel Programming | |||
Linear Mode
