+ Reply to Thread
Results 1 to 6 of 6

Multi-Page userform controls

Hybrid View

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    Long Beach, WA, USA
    Posts
    20

    Multi-Page userform controls

    Hi all,

    You're going to get so tired of hearing from me!

    I have a MultiPage userform and I'm adding (4) control buttons - CancelButton, BackButton, ForwardButton and FinishButton. On the first page, those names are fine but when I get to subsequent pages, I get an ambiguous error if I try to name the controls the same. But the code will all be the same. What am I missing? In an example that I have, the user was able to name all the controls with the same name. What setting would control that?

    Thanks so much for your help!
    Last edited by blue9244; 12-16-2008 at 11:44 AM.

  2. #2
    Registered User
    Join Date
    10-23-2008
    Location
    Long Beach, WA, USA
    Posts
    20

    Solved!

    I've discovered the solution myself. Thanks!

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Would you care to share your solution and mark the thread as solved

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You don't need multiple buttons, place them outside the multipage
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    10-23-2008
    Location
    Long Beach, WA, USA
    Posts
    20
    I'm not sure how to mark it solved. RoyUK hit the nail on the head - something I figured out not too long after my original post. Thanks, as always I appreciate any response!

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    There is a time limit which you need to see forum rules below for more info.

    All you have to do is
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1