dropdown menu

[Guest]

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

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Guest]

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

 

[Peo Sjoblom]

Assume you have a list in H2:H10 that is displayed in a validation dropdown,
if you do view>toolbars>control 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