Setting default values in a drop down list in excel?
Yes and no.
Here was my example. I sell furniture and wanted to write a program so that
when a desk sells there is an option to sell 4 parts with 10 different
colours. My problem was if only 3 parts were selected I wanted the colour to
read blank or please select automatically. I wrote an if statement for each
of the colours in the list which made the colour read 'please select' if the
desk field was blank. It wasn't exactly what I wanted but it does the job.
"Mitch" wrote:
Dave,
Did you solve this? I have the exact same question so if you have a
solution, please let me know.
Regards
Mitch
"Dave" skrev:
How do I set default values in a drop down list. I currently have a macro
which resets the sheet (resets the order number and customer cell for
example) but the options of the drop down menu cannot be reset this way. Can
anyone help?
|