Consulting

Results 1 to 4 of 4

Thread: Solved: Single Command Button on Multipage

  1. #1
    VBAX Regular
    Joined
    Nov 2007
    Posts
    28
    Location

    Question Solved: Single Command Button on Multipage

    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

  2. #2
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    Can you not just have the save button below (or above) the multipage control?

  3. #3
    VBAX Regular
    Joined
    Nov 2007
    Posts
    28
    Location

    Thumbs up

    Actually, come to think of it, I could. It never crossed my mind.

    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.

  4. #4
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    The simplest things are always the hardest to find - have a coffee on me!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •