PDA

View Full Version : Solved: Single Command Button on Multipage



artds
11-12-2007, 07:42 PM
Hi all. I am new in VBA, excel, and I am wondering if any of you can help me..

Is there anyway to use a single command button "cmdSave" on two pages of the multipage. i.e. evertime I change the page of the multipage, page 1 to page 2 and vice versa, the command button "cmdSave" will always be 'enabled'. Thanks.

Regards,
artds

geekgirlau
11-13-2007, 12:25 AM
Can you not just have the save button below (or above) the multipage control?

artds
11-13-2007, 02:17 AM
Actually, come to think of it, I could. It never crossed my mind. :doh:

I have design the multipage to stretched across the whole userform. So that possibility never came up! I Didn't even see it. I Think I need more caffein......

Thanks a million geekgirlau.:bow:

geekgirlau
11-13-2007, 05:06 PM
The simplest things are always the hardest to find - have a coffee on me! :coffee: