F
Fernando Duran
How you dropdown a list of option, and enter the result in another
cell?
Thanks
cell?
Thanks
F
Frank Kabel
Hi Fernando
not quite sure what you're trying to achieve. do you want to use 'Data
Validation' If yes, the result of your selections is always stored in
the cell with the listbox.
You may use a 'Combobox' and link this to a different cell as
workaround
not quite sure what you're trying to achieve. do you want to use 'Data
Validation' If yes, the result of your selections is always stored in
the cell with the listbox.
You may use a 'Combobox' and link this to a different cell as
workaround
F
Fernando Duran
I used a combobox. it reads my data, but instead of putting my choice,
it write a number, like indice, why?
it write a number, like indice, why?
B
Bob Phillips
You can also have another cell linked to the DV cell. If the DV cell is A1,
in an other cell =A1 shows what was picked.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
in an other cell =A1 shows what was picked.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
F
Frank Kabel
Hi Fernando
you may change the 'Textcolumn' property of your combobox to the column
number of your data source which you want to display (have a look at
the Excel help at 'Boundcolumn' and 'Textcolumn')
you may change the 'Textcolumn' property of your combobox to the column
number of your data source which you want to display (have a look at
the Excel help at 'Boundcolumn' and 'Textcolumn')
F
Frank Kabel
o.k. agreed (and format the cell with data validation with a custom
format which uses a white font color)
B
Bob Phillips
No you're just being silly<G>
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
F
Frank Kabel
Bob
so many good ideas from both of us and the OP uses a combobox <vbg>
so many good ideas from both of us and the OP uses a combobox <vbg>
B
Bob Phillips
Frank,
Actually the linked cell to a DV cell is not so silly. I use it in XL97 when
trying to have a change event on a DV cell, as in XL97 DV does not trigger
the change event. so I use the Calculate event to do the work as well, which
gets triggered by the linked cell being automatically updated. Messy, but it
works.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Actually the linked cell to a DV cell is not so silly. I use it in XL97 when
trying to have a change event on a DV cell, as in XL97 DV does not trigger
the change event. so I use the Calculate event to do the work as well, which
gets triggered by the linked cell being automatically updated. Messy, but it
works.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
D
Debra Dalgleish
If you use the combo box from the Forms toolbar, it enters the item's
index number in the linked cell. In another cell, you can use the INDEX
function to pull the value from a lookup list, e.g.: =INDEX(A1:A12,E2)
Or, use a combo box from the Control toolbox. It will insert the
selected item into the linked cell, instead of a number.
index number in the linked cell. In another cell, you can use the INDEX
function to pull the value from a lookup list, e.g.: =INDEX(A1:A12,E2)
Or, use a combo box from the Control toolbox. It will insert the
selected item into the linked cell, instead of a number.