+ Reply to Thread
Results 1 to 6 of 6

Thread: Userform Multipage User Control Lock

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    60

    Question Userform Multipage User Control Lock

    Hello,

    I have created a multipage userform in VB 6.5 and was wondering how to prevent the user from advancing through the form by simply selecting the tab. In other words, I would like to force them to use the "Next" and "Previous" buttons i have created to navigate the pages. Currently, they are able to skip through by selecting the tabs at the top.

    Thanks!
    surge (first timer)

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Userform Multipage User Control Lock

    You could simply hide the tabs?

  3. #3
    Registered User
    Join Date
    05-23-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Userform Multipage User Control Lock

    I do not want to hide the tabs. I want the user to see the various sections of the form, but only be able to reach them through the coded "Next" button i have created. I simply want to disable the selection of the tab itself.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Userform Multipage User Control Lock

    If you hide the tabs, you can replace them with labels if you wish. I do not know of any way to disable the tabs themselves.

  5. #5
    Registered User
    Join Date
    05-23-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Userform Multipage User Control Lock

    could you please guide me through that process?

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Userform Multipage User Control Lock

    Set the Style property of the multipage to 2 to hide the tabs, then draw labels above the control with the relevant caption for each tab. You can use the Change event of the control to show/hide the labels, or make one's font bold etc.

+ 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.2.0