Hello ,
I was wondering if it's possible to use this macro code in a toggle to perform this action when it's true and when the toggle is click again it can undo it.
This macro does lookups and finds the max on sets of value when it is run and i was wondering if by clicking the button again it can undo what it placed in the cells...
Any thoughts?
Gratias...
Please Login or Register to view this content.
Last edited by Preatorian; 07-28-2009 at 09:21 AM.
Do you mean delete the formulas?
Once the macro has run the first time the rngData variale will be cleared, Excel cannot store the variable so when you lick again there will be no blank cells to set the variable to.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hmm, lets see.
The macro runs and places the data in the cells accorindgly, right now it is also place the formula as well. What i was thinking is that the toggle would clear the data in the cells.
So, in simplest terms, toggle clicks, runs macro, places data in cell. Click macro again and remove the data.
Is this something tha can be done?.
Gratias,...
The issue is that you find the cells originally by looking over a range for the blanks. You can't then do that again as they will no longer be blank.
If you are just wanting to Clear the cells on the second click, (so that they are empty) you could do something like this:
Please Login or Register to view this content.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
Kool...You da man.
No need to use toggle with this...Works great.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks