Macro driven pickbox

R

RogerNZ

What I want to do is use a button controlling a macro, when I select the button, the macro runs showing me a drop down (macro driven) list of text options (which are either referenced from cells on the sheet or text input in the macro), I select the option I want, hit enter and it puts my selection in a cell defined in the macro.

I am fed up with pick boxes and or data validations not working correctly, besides it makes the screen look messy.
 
Top