+ Reply to Thread
Results 1 to 3 of 3

Set focus to a page or tab in a userform

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Set focus to a page or tab in a userform

    Hi all,

    Running into some problems with my userform. I currently have the form set so that if certain fields are left blank when the 'OK' button is pressed then a msg box pops up and I use the Setfocus to bring the user back to that field. This also stops the form from closing and entering the incorrect data. The problem I am having now is that I have used the multipage and tab strip buttons in my userform and when I try to set the focus to a text box on the multipage or tabstrip I get the following error:

    "Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus."

    I have tried to work around this using "Cancel=True" but to no avail.

    I could have everything on one page but I am trying to keep the userform organized and clean.

    Any insight you can offer would be greatly appreciated!

    wolfman

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Set focus to a page or tab in a userform

    Please attach your work and I'll try to amend.

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Set focus to a page or tab in a userform

    I'm sorry I've decided to go about this another way... Will post code when I finish project. Thanks!

+ 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