ComboBox,Array and Index numbers

[Dennis Hightowe]

I have devloped a small array of names and numbers. I have filled a
combo box with the information from one column of the array. I have set
the control source to put the index number in a specific cell on a
specific worksheet. When I run the user form I do not get the index
number I get the text instead. I changed the bound column to 0 but I
still do not get the index number in the cell. When I exit I see the
index number appear in my combobox drop down . I am new to VBA for
Excel programming so any help is certainly appreciated

 

[Norie]

Dennis

When you say index number do you mean the actual index number of the
item in the combobox or the number associated with the name on the
worksheet?

If it's the first I think you would need code to get the number into a
cell.

If it's the second you should make the combobox have 2 columns, one for
the name and one for the number.

The make the bound column the one with the number and hide it.

 

[Dennis Hightowe]

Thank you for the information. The number that I am trying to get is th
actual index number of the selected item in the comboBo

 

[Bob Phillips]

If it is the first one, and we are talking a control toolbox combo, then
just set the BoundColumn to 0.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

See my response

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dennis Hightowe"