Hello,
I am selecting multiple worksheets in a workbook.
While those are selected, I am clicikng on a cell on the active worksheet, say I click on B5.
At this point I want to run a macro which displays in a message box the current values on cell B5 of all selected workseets along with the correspnding worksheet name like:
B5 on Sheet3 is: x
B5 on Sheet6 is: y
B5 on Sheet9 is: z
and so forth..
Could you please advise on such a script?
Thank you
See attached snapshot of the selected worksheets.
Thanks
You'll have to double click on the cell in question.
You'll have to put this in all sheet modules.
Please Login or Register to view this content.
Last edited by jolivanes; 06-25-2022 at 08:42 PM.
Experience trumps academics every day of the week and twice on Sunday.
Yhank you jolivanes!
Maybe this is easier on the "memory" part. No remembering required if many sheets are selected.
Please Login or Register to view this content.
Yes, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks