HELP!!!! needed in Excel

[[email protected]]

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

[Ivan Raiminius]

Hi,

try using match function:

=match(data value,original list used to fill combobox,0) should give
you the index you are looking for (in case first index was 0, substract
1 from match result)

Regards,
Ivan

[[email protected]]

i used this to fill the combo box ListFillRangeSummary!$IS$1:$IS$1188
where Summary is another worksheet.

now i want the index of the data in the list in the cell p3 of this
page the (form type) list box was doing this automatically but the
(control type) Combo Box is giving me the value stored in IS of summary
sheet.

what do u mean by data value in
=match(data value,original list used to fill combobox,0 )

[Ardus Petus]

Try the .Topindex property of Combobox

HTH
--
AP

"Ivan Raiminius" <[email protected]> a écrit dans le message de
news: [email protected]...
> Hi,
>
> try using match function:
>
> =match(data value,original list used to fill combobox,0) should give
> you the index you are looking for (in case first index was 0, substract
> 1 from match result)
>
> Regards,
> Ivan
>

[Ivan Raiminius]

Hi,

I mean the value you call data value (the value combobox returns to
excel sheet).

Regards,
Ivan

[[email protected]]

i cant change the topindex and now it is giving the error of "some not
enough system resources to display completely" when i inserted the
whole list of 1200 values