Conditional Hyperlink (macro) based on cell content

[arif120]

I want to create a Hyperlink (macro) based on cell value Sheet1!A1, where Sheet1!A1 contained formula and is always numeric. This is noted that others Sheets like Sheet2, Sheet3, Sheet3 etc. are always hidden.

e.g. if Sheet1!A1=2 Go To Sheet2,
if Sheet1!A1=3 Go To Sheet3,
if Sheet1!A1=4 Go To Sheet4, etc.

Please someone help me.

 

[vletm]

arif120
Write number to cell A1 ...

 

[arif120]

It works properly, but i wanted to add a button, in which i click it would word.

 

[vletm]

arif120
... hmm?
Where suddenly comes need to have a button?
Of course, You can add a button and click it.
... or dropdown.

 

[arif120]

Thanks, i got my solution forum.chandoo.org is one of the best forum.