Command button to open worksheet based on cell criteria

[ccaliame]

Hi, I need help with the following,

Scenario: I Require a command button to open a worksheet based on the text in a particular cell.
i.e. if cell b3 contains "apple", then open worksheet called "apple" only when the command button is clicked - (note cell b3 is a Data Validation box).

I have searched & tried to put together bits and pieces but to no avail...

Any help on this would be appreciated,

Cheers,

 

[JoeMo]

Put this in a standard module and assign it to a forms control command button on the sheet with the B3 data validation.

Sub ActivateSheet()
On Error Resume Next
Sheets(CStr([b3])).Activate
On Error GoTo 0
End Sub

 

[ccaliame]

Hey JoeMo,

Legend, thank you, it is exactly what I am after, thanks for your help, I really appreciate it!

Cheers,

 

[JoeMo]

Hey JoeMo,

Legend, thank you, it is exactly what I am after, thanks for your help, I really appreciate it!

Cheers,

You are welcome - thanks for the reply.