Enter values in a column with combo box selections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can probably use the SelectionChange event to call the ComboBox. See VBA
help for info on the event.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box 2
Linking Combo Box Values to Access Table 2
Combo Box and Multiple row / column display 2
Access Control on subform / combo box requesting parameter 0
combo box - last value 2
finding line number selected in combo box 5
Combo Box question 5
combo box selection issue 2

Back
Top