S
SmokingMirror
This is probably a simple query, but, try as I might, I cannot get m
worksheet running properly.
Essentially, I'm trying to insert a dropdown combo list into a cell o
my worksheet. I'm using the combobox option from the FORMS menu.
I've inserted the box successfully into the required cell on th
worksheet, and, in its Input Range I've listed T2:T14 (13 cells whic
each contain a different value) in order to populate the list. Thi
all works properly, and I've got a nice looking combox box from which
can select any of the values from cell T2 to T14.
The problem arises when I try to output the selected value in order t
further manipulate the chosen selection.
The combobox's format menu has its Cell Link listed as O5, but th
problem is that the final result (O5) lists the number of th
selection, NOT - as it should - the actual data.
For example, cell T2 contains the data 10, whilst T3 contains the dat
68. However, in the current setup, selecting T2 (10) from my combolis
results in the reporting cell, O5, to list 1, which is the datas plac
in the whole list, not the actual data itself.
How can I get my reporting cell to give the data value selected, an
not it's position in the dropdown list??
worksheet running properly.
Essentially, I'm trying to insert a dropdown combo list into a cell o
my worksheet. I'm using the combobox option from the FORMS menu.
I've inserted the box successfully into the required cell on th
worksheet, and, in its Input Range I've listed T2:T14 (13 cells whic
each contain a different value) in order to populate the list. Thi
all works properly, and I've got a nice looking combox box from which
can select any of the values from cell T2 to T14.
The problem arises when I try to output the selected value in order t
further manipulate the chosen selection.
The combobox's format menu has its Cell Link listed as O5, but th
problem is that the final result (O5) lists the number of th
selection, NOT - as it should - the actual data.
For example, cell T2 contains the data 10, whilst T3 contains the dat
68. However, in the current setup, selecting T2 (10) from my combolis
results in the reporting cell, O5, to list 1, which is the datas plac
in the whole list, not the actual data itself.
How can I get my reporting cell to give the data value selected, an
not it's position in the dropdown list??