+ Reply to Thread
Results 1 to 2 of 2

Multipage form set focus

  1. #1
    Registered User
    Join Date
    04-03-2010
    Location
    Orlando, FL
    MS-Off Ver
    Office 365
    Posts
    94

    Multipage form set focus

    Hi All, I have a multipage form in my workbook that, on the Activate event, opens to the first page with:
    Please Login or Register  to view this content.
    This is working fine. However, on the second page I have a date field that, when entered, opens up a simple date form, with an OK and Cancel button. If either of these are pressed, I want the form to close and the focus to remain on the second page. I've tried various iterations of this code, but none of them work. The focus always goes back to the first page.
    Please Login or Register  to view this content.
    ...any ideas?

    Note: This was originally posted here but got no response: http://www.mrexcel.com/forum/excel-q...set-focus.html

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Multipage form set focus

    Hello
    You've got the UserForm1 Activate event set to MultiPage1.value =0, so when it's activated that's the page with focus. Is there any reason you're setting this event so? Page 1, I believe is its default focus.

    DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] ActiveControl - Return non-Multipage control when Form contains Multipage?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 08:37 PM
  2. Setting Page Focus With MultiPage
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2011, 01:45 AM
  3. MultiPage Form
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2010, 06:04 AM
  4. multipage set focus help
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2007, 09:57 PM
  5. Focus on Multipage#
    By jonn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2007, 12:05 PM

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