combobox

[rbacon100]

Is it possible to make combobox list from cell drop down list.

For example, cell has drop down list. Is it possible to make combobox based on that cell. So it show same list like dropdown in normal excel?

Thanks in advance

 

[GS]

Is it possible to make combobox list from cell drop down list.

For example, cell has drop down list. Is it possible to make combobox
based on that cell. So it show same list like dropdown in normal
excel?

Thanks in advance

Absolutely! But more details are needed...

Is the DV list manual, stored in a range, or stored in a defined
name?
If stored in a range, is it named?

Where is the combobox used?
If on a worksheet, what type? (Form or ActiveX)

Does the list need to be dynamic? (auto-updates)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[bojan0810]

Hi there. Thanks for reply.

List will not change, at least not in near future. And it doesnt matter if range is named or in range, as it can be both. It is named now, but if things can be easier with range only, it is easy to change, not a problem.

And I am using activex combobox, but again if form is better, that can work too...

Only thing I need is that same list is showed in combobox from desired cell. For example if I have 10 comboboxes and I want that all of them show list from 1 cell where is data validation, I want to show that list in all of them.

Or that or maybe it is easier to make popup combobox on cell where is datavalidation.

I found example online with that, but it only works in that file. I tried to make same, but it didnt worked on mine.

 

[Claus Busch]

Hi,

Am Thu, 16 Oct 2014 04:12:42 -0700 (PDT) schrieb (e-mail address removed):

And I am using activex combobox, but again if form is better, that can work too...

try:
ComboBox1.ListFillRange = Range("A1").Validation.Formula1
to fill the combobox


Regards
Claus B.

 

[rbacon100]

Thank you Claus.

That worked. I looked everywhere and I couldnt find it. And it was so simple.

Thank you very much. You helped me and my friend alot.