Set default values marco

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

Guest

I have a model where there are several user defined entries. The ones I can't seem to get to work are resetting a value from a drop-down menu. When recording the macro it does not acknowledge a selection from the drop-down menu. Due to the complexity of the model I want to add a reset defaults button to reset all the values on a worksheet. If anyone knows how to get a macro to reset a value from a drop-down menu please let me know.

Thanks!
 
What kind of drop-down are you talking about? Are you refererring to
combobox that has been added to the workbook from one of the toolbar
or are you talking about a cell with a drop-down data validatio
added?

Rolli
 
You must log in or register to reply here.

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

Setting default values in a drop down list in excel? 2
Drop Down Default 1
Using an Excel macro to reset a drop down list 2
Recording new Macro won't reset drop downs 3
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Marco issue 3
macro 1
Excel Excel: How do I put a formula in a drop down list 11

Back
Top