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

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

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