Hello all,
What I am trying to do is use a range of cells P3:R29 on sheet Entry that when clicked put an X in the cell clicked on and a corresponding cell range Q3:S29 on sheet Master. I figured out how to do this in just one cell but not the range. Any thoughts on how/if this is possible?
Thank You,
Ben
Last edited by Ben Bristow; 03-23-2017 at 01:43 PM.
This is how I would approach this, this event code goes in the Entry sheet module:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you Jerry for the quick response. This is a different approach than I have seen. It worked for cell Q3 but none after that. Any thoughts?
Last edited by Ben Bristow; 03-23-2017 at 02:19 PM.
Oops, that should be a BeforeDoubleClick event.... my bad... so doubleclick any of those cells to cause this effect.
Please Login or Register to view this content.
Jerry, You are a genius. That is perfect. Thank you so much. You just made my spring break. If you ever need website help let me know.
Thank You again,
Ben
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks