+ Reply to Thread
Results 1 to 1 of 1

Multipage Setfocus Problem after IF is executed

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Mansfield, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    Multipage Setfocus Problem after IF is executed

    This is my first post, so please bear with me. I am trying to finish up my first UserForm ever. Workbook is attached since I cannot really pinpoint what may be causing my SetFocus in the Private Sub txtde30_AfterUpdate() to not work properly. I have other setfocus statements within other subs that are working ok.

    This is a MultiPage User From. I have an If statement where when true, execute some code, then I want to set focus back to a text box on that page after the text boxes were cleared. It keeps going to the next command box control instead.

    I have tried _Change() ,_Exit(ByVal Cancel As MSForms.ReturnBoolean), _BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean). Some of these ended up goofing up clearing the text boxes, some just kept going to the next command box.

    I realize this code overall is not the best written, but it is working well for everything I want except this one setfocus.

    Thank you for any assistance you can give.

    P.S. The only choices for the dropdown boxes on the Summary page that are built are for Distribution. Others are under construction.
    Attached Files Attached Files
    Last edited by DBarker2006; 08-09-2013 at 08:36 AM. Reason: additional information

+ 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] Problem with SetFocus
    By exceln00b22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2013, 02:22 PM
  2. SetFocus on Multipage
    By mshorkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2006, 02:46 PM
  3. [SOLVED] Excel 2003, can't setfocus in a textbox inside a multipage, tab key don work!
    By carlosla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2006, 04:00 PM
  4. [SOLVED] setfocus in textbox on multipage
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2006, 12:25 AM
  5. [SOLVED] SetFocus problem
    By JH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2005, 11:06 AM

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