ComboBox,Array and Index numbers
 

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


--
Dennis Hightowe
------------------------------------------------------------------------
Dennis Hightowe's Profile: http://www.excelforum.com/member.php...o&userid=23723
View this thread: http://www.excelforum.com/showthread...hreadid=373998

ComboBox,Array and Index numbers
 

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.


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=373998

ComboBox,Array and Index numbers
 

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

--
Dennis Hightow
-----------------------------------------------------------------------
Dennis Hightowe's Profile: http://www.excelforum.com/member.php...fo&userid=2372
View this thread: http://www.excelforum.com/showthread.php?threadid=37399

ComboBox,Array and Index numbers
 

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)


"Norie" wrote in
message ...

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.


--
Norie
------------------------------------------------------------------------
Norie's Profile:
http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=373998

ComboBox,Array and Index numbers
 

See my response

--

HTH

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


"Dennis Hightowe"
<Dennis.Hightowe.1pm0cr_1117061212.4642@excelfor um-nospam.com wrote in
message news:Dennis.Hightowe.1pm0cr_1117061212.4642@excelf orum-nospam.com...

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


--
Dennis Hightowe
------------------------------------------------------------------------
Dennis Hightowe's Profile:
http://www.excelforum.com/member.php...o&userid=23723
View this thread: http://www.excelforum.com/showthread...hreadid=373998