I'm trying to make a code so that when optionbutton1 is checked, it allows you to right click to select a cell, then right click on a different cell and select that cell as well as the previous cell, etc. Here's What I have so far.
Please Login or Register to view this content.
Last edited by TheSpriceEffect; 07-16-2014 at 09:37 AM.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you so much! What about if left click then forget the selection?
You're welcome.Originally Posted by TheSpriceEffect
I don't understand?
Right now, while right clicking it will add cells to the selection ever time you right click a different one, but there is no way to end that process. Lets say I've used that method to select a bunch of cells and then I changed a property about them. Then I want to clear this selection from the variable S so that I can start the right clicking process over again.
Never mind, figured it out! thanks
Remove this line from the previous code.
Static S As Range 'Persistent
Add this to the very top of any standard code module e.g. Module1
Public S As Range
In whatever procedure you run that changes the S range property, add this at the end of that procedure to reset the S range.
Set S = Nothing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks