HELP!!!! needed in Excel
 

hi everyone
i have got a new problem this time. I have managed to populate the data

and all in the Combo box and its doing first letter select. but the
trouble is earlier in the list box (form type) when i used to select an

option i used to set the data in another cell.
it was giving the index of the data and i was doing some calculations
on the basis of this index value(it was a numeric value.)

but now when i select from the combo box its giving me the Data value
from the list which is of no use as far as my calculations are
concerned as its a data value and (not numeric). so what should i do to

get the index value instead of the exact text from the list in the
combo box.


I tried using bound column and set another column containing the index
of the list but its not working. even column count is of no use


plz help out.
thanx in advance

HELP!!!! needed in Excel
 

If you set the boundcolumn property to 0, then the Controls Toolbox Toolbar
Combobox will return the ListIndex property as both its Value and to any
linkedcell/controlsource.

Note that Forms controls have a value of 1 for the index of the first item -
while control toolbox toolbar comboboxes and listboxes have a value of 0 for
the index of the first item.

--
Regards,
Tom Ogilvy


" wrote:

hi everyone
i have got a new problem this time. I have managed to populate the data

and all in the Combo box and its doing first letter select. but the
trouble is earlier in the list box (form type) when i used to select an

option i used to set the data in another cell.
it was giving the index of the data and i was doing some calculations
on the basis of this index value(it was a numeric value.)

but now when i select from the combo box its giving me the Data value
from the list which is of no use as far as my calculations are
concerned as its a data value and (not numeric). so what should i do to

get the index value instead of the exact text from the list in the
combo box.


I tried using bound column and set another column containing the index
of the list but its not working. even column count is of no use


plz help out.
thanx in advance

HELP!!!! needed in Excel
 

than you so much for your help. i used VBA instead and set the property

ComboBox1.ListIndex
on change
thus i could also call the macro which i had written earlier.


thanx an regards
Shreya