Navigate to sheet via VBA

[ola7mat]

Hello,

I have this nifty little VBA code that changes the to an active chart when i select a cell.

However, i am trying to adapt it so that it will allow sheet selection too.

I.e. when i type inside the cell and click it it takes me to the chart (the worksheet has about 30+ charts), but i want it also to send me to a sheet when i select the cell, i did try adapting it but failed with the if/s?

Can anyone help?
--

Please Login or Register  to view this content.

Moderator's Note: Please use code tags when displaying code. Forum Rule #3

[MrMcLee]

I have a macro that takes me to a specific sheet in a different workbook based on the value of a cell.

Please Login or Register  to view this content.

This is dumbed down code. The real code also copies and paste several cells, but I think this is sort of what you're getting at.

[ola7mat]

Thanks MrMcLee

I cant seem to adapt this to my code already.
What i was ideally looking for was some advice on how to adapt it, and include another if argument that on error i.e. when it cant find the chart
it looks for the worksheet based on the value of cell I2?