Code execution just before tab in multipage control switches

craigyg

Board Regular
Joined
Dec 14, 2005
Messages
114
Situation: User selects a new tab on a multipage control

I need code to execute just before the new tab is selected, i.e. on the way out of the last tab. Ideally, I would like this to happen when the user selects a new tab: The selection of the new tab pauses and lets some code execute before it is activated. I have been able to do this kind of thing for comboboxes using the Enter event but I can't seem to figure it out for change of tabs on a multipage. Is there any way to do this? Thanks

- Craig
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,114,415
Messages
5,547,807
Members
410,813
Latest member
Vhinzvirgo
Top