+ Reply to Thread
Results 1 to 1 of 1

Automated Combobox not working properly

  1. #1
    Registered User
    Join Date
    09-11-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Professional 2013
    Posts
    1

    Automated Combobox not working properly

    Hi Folks, my first time asking for help here. I'm a newbie trying to learn some tricks.

    I created 2 combo box to deal with 2 different dropdown lists. I then create an automation to call the combobox with doubleclick on the cells where the dropdown should be.

    If I doubleclick in Column 'P' (16) it calls the combo box "CostCentreCombo". If I doubleclick on the column 'Q' (17) it calls the combobox "GLCodesCombo".

    It's almost everything good but one problem. I notice that after I call one of the combobox, use the dropdown to select a value then I get out of it just clicking in any other cell, I can't do it again on the next cell immediately. if I double click on another cell, the combobox will appear but the dropbox will not. If I simply click again on the same combobox that worked and don't select anything from the dropdown, then I can go to the second combobox. It's just a weird thing that may be happening when I LoseFocus from the object, but I don't know how to handle it. The whole code is provided below. I also include the excel file. Just go on 'Invoice' tab and double click on either collumns P or Q. Any thoughts?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Hetnon; 09-11-2020 at 02:37 AM.

+ 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] listbox and combobox not populating properly
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2017, 04:26 AM
  2. Combobox not working properly
    By flummiht in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2015, 06:47 PM
  3. Automated username VBA not working
    By angel2903 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2014, 04:06 PM
  4. [SOLVED] Can't get combobox to properly fill data based on another combobox.
    By Orestees in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2012, 05:22 PM
  5. Protect/Unprotect Procedure with Combobox not working properly
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2011, 04:43 PM
  6. UDF not working properly
    By demuro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2008, 04:36 PM
  7. [SOLVED] Automated Delete Item from ComboBox List
    By ToferKing in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-23-2006, 02:50 PM

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