VBA IF cell in a specific sheet is equal to a number, the go to a specific sheet

[nickthebizz]

Hi, my skills in VBA is at beginning level.

I have a sheet where I have my clients names written. I have made a button and I would like this button to take me to a specific sheet when each client is selected. I have manage to make a list where when i choose a client it returns a number in a cell starting from 1 and on in my clients sheet.

So if this number is equal to 1 I need the button to take me to a specific sheet which is for that specific client. If the cell is equal to 2 to another sheet etc.

Could anyone give me an insight please

thank you

Nik

 

[My Aswer Is This]

So it looks like you have the solution
But I thought in post 3 you said button was in sheet named "Main:
Your quote in post 3
Name of Sheet with Button is "Main"

Or all you putting buttons in more then one sheet?

If so write code like this: ans=Activesheet.name

If your interested:
We can use a script where you enter "2" into Range("A1") and the script runs automatically
No need for a button in each sheet.
Let me know if your interested.