I'm trying to create a macro where if a cell contain a specific value, the person using the Excel document will be moved to a different worksheet. Can any one help with this?
Thank you
I'm trying to create a macro where if a cell contain a specific value, the person using the Excel document will be moved to a different worksheet. Can any one help with this?
Thank you
Hi kingy12321
Welcome to the Forum...
I am very certain that this can be achieved, however, we will need a bit more info...
What action makes this macro run...cell selection, a button, ???
What do you mean by the person using the Excel document will be moved to a different worksheet...does this mean that different sheet is activated?
Also...Please upload a sample file with exact setup to explain
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Bring up the VBA Editor using Alt+F11 then double-click the "ThisWorkbook" module (on the left) and paste the following:
Change the constants at the top to represent the sheet names that you're working with, the cell/range you want to check and the value you're looking for.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
This is perfect! Thank you for your help
Is there a way I can implement this in with a button, so when the button activates a formula to display "Y" it will change the worksheet?
Thank you again for your time and help
I'm not quite sure what you mean? Buttons don't activate formulas? Could you explain in a bit more detail?
WBD
Im unable to uuplaod an the excel sheet to explain sorry.
If "A1 + B1 = C1" IF "C1= 10" move user to "sheet 2".
thank you for your help.
Last edited by kingy12321; 04-24-2020 at 05:25 AM.
That would be like this:
WBDPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks