list box

[pchildress285]

I have list box with selectable options and several cells for inputting data into. I'm looking to create a reset button that returns list box values back to the first one in the list and clears all cells at the same time. I need a step by step layout of the macro. I am new at macros and starting to learn about them. Thanks in advance.

 

[BrandonWLH]

Developer Tab
Record Macro
Do what you want the macro to do.
Stop Recording Macro.

Right click on the sheet name at the bottom, View Code, go to module 1 in the object browser and you can see the code the Excel generated for the actions you did. Always a good place to start if your unsure how to do something.