Multiple Check boxes - how to select another worksheet using a single function

Hi,

I'm not very clued up with the conditional formatting or programming side of things in excel and I'm really struggeling to figure out how to put together some simple coding that will allow a checkbox when selected to change to a different worksheet?

I have a list of checkboxes, each one refers to a different worksheet. Is there some simple coding I can use which will allow me to select a particular checkbox but all within the same function or do I need to have a separate function for each selection made?

Also, if I return to the page where the check boxes are located, how do I get them to all be reset to 'Unchecked'?

Any help would be greatly appreciated. I am not currently using any Macro's.

Thank you in advance.

Skelvissie,

Instead of using checkboxes, wouldn't it be easier to insert hyperlinks to the different worksheets? See attached for an example

Hope that helps,
~tigeravatar

Hi Tigeravatar,

You are brilliant!!

Thank you, I have been struggeling with this silly document for ages trying to come up with something really fancy and it never once crossed my mind to use a simple function such as a hyperlink. I am a real doofus...doh! Thanks, I think I might just be able to finally get this document done today, you are a star! Thank you again

Cheers,