Hi,

I have a workbook that when opened displays a user form with two buttons. Each button goes to a different worksheet. Basically it gives the option of which worksheet you want to start with. I have a MsgBox that displays with instructions after you make your selection. Then on the sheet you open there is a button to go to the other sheet. I am trying to have that button prompt a MsgBox if the other sheet has not yet been selected. I can get excel to recognize the sheet has been selected once it is toggled to from the other sheet however when I go back to the first sheet it thinks it is the first time. I tried adding code to the form button on_click to increment an occurance variable I have but that does not seem to store whe nthe form is unloaded. Also the occurance variable is declared to the workbook so not within a Sub. Any help?