VBA Buttons!

you'll need to specify the cells that you target for those operations..

also, include the name of sheet you will do those operations..

Originally Posted by ag273n

you'll need to specify the cells that you target for those operations..

also, include the name of sheet you will do those operations..

Here we go!

Clear all...
E4-E300, H4:M102, M2, O4

Paste...
E4-E300

Now, I'm thinking that I would need a Clear Button for E4-E300 also.

"Billing" is the name of the sheet...

you'll need to add a button
go to developer tab (if its not showing, google it.. thats pretty easy)

click "insert"
under the active X controls - click command button

your mouse will look like a plus sign, just click and drag in a diagonal direction across the cells
once you have a button, right click on it then select "properties"
then change the caption , type there "Clear All"

then double click the button you created

then paste this on the sheet that will appear

(this is assuming that the range you will clear doesnt change)
(erase everything in there before pasting this)

Please Login or Register  to view this content.

*now assuming you already coppied the stuff you wanna paste

go again to the developer tab and create a new button
click insert
then under the active X controls - click command button
and like the previous step, just click and drag across the sheet so you can make a button
then the same, just right click on the button and click properties,
then change caption to "Paste"

then doubleclick the button you just created again.. then paste this (just below the code you pasted earlier)

Please Login or Register  to view this content.

in your developer tab, you'll see at the top that the "Design Mode" is highlighted, click it just once to disable it.. so you can use your new buttons now