Setting default values in a drop down list in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop Down Default 1
Using an Excel macro to reset a drop down list 2
Excel Excel: How do I put a formula in a drop down list 11
Select drop down menu option using libre-calc macro 0
Recording new Macro won't reset drop downs 3
Drop down list and macros? 1
Drop down list 1

Back
Top