Conditional Hyperlink (macro) based on cell content

[Ariful Islam]

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. Sheet1!A1=2 Go To Sheet2,
Sheet1!A1=3 Go To Sheet3,
Sheet1!A1=4 Go To Sheet4, etc.

Please someone help me.

 

[Eric W]

Try:

=HYPERLINK("#Sheet"&A1&"!B2","Go to Sheet"&A1)

where B2 is the cell on the target sheet you want to go to.

 

[Ariful Islam]

Sir, I need a macro/vb code.

 

[Eric W]

    v = Sheets("Sheet1").Range("A1").Value
    Sheets("Sheet17").Range("A11").Formula = "=HYPERLINK(""#Sheet" & v & "!B2"",""Go to Sheet" & v & """)"

or

    v = Sheets("Sheet1").Range("A1").Value
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "Sheet" & v & "!B2", TextToDisplay:="Go to Sheet" & v

 

[Ariful Islam]

Thanks a lot