dropdown menu
 

How do I show a dropdown menu when I am not in the cell?

dropdown menu
 

Use a combobox from the control toolbox toolbar, you cannot use validation
and get this functionality


--


Regards,


Peo Sjoblom


"msmary" wrote in message
...
How do I show a dropdown menu when I am not in the cell?

dropdown menu
 

that was good, thank you. But how do I insert information on this menu

"Peo Sjoblom" wrote:

Use a combobox from the control toolbox toolbar, you cannot use validation
and get this functionality


--


Regards,


Peo Sjoblom


"msmary" wrote in message
...
How do I show a dropdown menu when I am not in the cell?

dropdown menu
 

Assume you have a list in H2:H10 that is displayed in a validation dropdown,
if you do viewtoolbarscontrol toolbox and drag the combobox unto the
sheet, then right click it and select properties the properties window
opens, look for ListFillRange in the left section and put H2:H10 in the box
next to the right of ListFillRange. You also need a linked cell where you
want the selection. You can also change font size etc using this. Finally
click on the triangle to close the design mode


--


Regards,


Peo Sjoblom


"msmary" wrote in message
...
that was good, thank you. But how do I insert information on this menu

"Peo Sjoblom" wrote:

Use a combobox from the control toolbox toolbar, you cannot use
validation
and get this functionality


--


Regards,


Peo Sjoblom


"msmary" wrote in message
...
How do I show a dropdown menu when I am not in the cell?