Referencing a ComboBox

Y

Yury

I have 7 combox in a sheet. I create a array with their names, and want to
get their list index. I tried :

Dim escolha As ComboBox


escolha.Name = arrCombos(1)
value = escolha.ListIndex ()

But I get a 91 error. How can I do this?
 

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

VBA Coding Help for Beginner 0
Automatic indexing in footnotes - solved 0
VBA - exporting serial letters to single documents 0
Combo box 0
Can't select option in combobox 0
Weekly Report 2
Combo boxes in excel 6
Need help modifying code 0

Top