Add multiple Macros to single click Command Button

Dellpanther

New Member
Joined
Oct 23, 2019
Messages
4
Hi all,
I want to reset both my data validation dropdowns and manual entry cells with a single click of the Command Button. I already have the code for the dropdowns from a previous thread, what Macro/VBA should I enter to reset all manual entry cells to blank, and how do I combine the two to a click of the Command Button?

Please note, I have zero experience with Macros/VBA so please be as specific as possible.

Thank you in advance!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Richard U

Active Member
Joined
Feb 14, 2006
Messages
377
Assign a named range to the manual input cells by selecting those cells then typing in a name in the name box (located next to the insert function key)

For the sake of argument, lets say we're calling it Manual_Input

then in the code, you just type in...

Code:
range("Manual_Input").clearcontents
 

Forum statistics

Threads
1,089,271
Messages
5,407,310
Members
403,132
Latest member
Black_Mamba_1666

This Week's Hot Topics

Top