+ Reply to Thread
Results 1 to 2 of 2

Messagebox triggers before the Focus gets to object

  1. #1
    Registered User
    Join Date
    08-18-2007
    Posts
    62

    Messagebox triggers before the Focus gets to object

    I have a excel data entry form that has several objects; combo, text boxes, check boxes etc.. One of the objects is combo box, which has a sub routine that validates the input, so an option has to be chosen. The problem is that before the combo box gets the focus it pops the message up!? The tab order goes from a Frame containing two Option Buttons than another Frame with 2 disable option buttons that are disable, then when I tab out of the frame in to the combo box the message a window pops up with the alert of not entering a value. Does anybody have an idea what is triggering the msgbox to pop before the focus gets to the cbobox?
    This is the code for the combo box;

    Please Login or Register  to view this content.
    Also I changed the tab order to skip the disable Frame (with 2 option buttons) and the combo box works fine waits for the right input if it does tabs to the next object, but if no value is entered it pops the message box alert.
    What is the disable frame doing to make combo box to trigger the message box?
    Any input will be greatly appreciated.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    I'd try putting the validation in the ComboBox_BeforeUpdate event.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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