Would be very grateful for any help on this one..

I'm trying to create a form that will bring up a sheet in excel when
the "tick to continue" tick box is checked.

I've read the bits on worksheet events but haven't got a clue how to
adapt to my use - only ever used the macro recorder and done bits of
changes to existing visual basic.

Basically, I would like to have the form select 1 of 3 different sheets
depending upon the value of a cell, say A1, which is defined by other
entries made earlier and I'm thinking of using the tickbox as the
trigger but any other option considered!

many thanks

David



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/