Consulting

Results 1 to 8 of 8

Thread: Bug? with activeX combobox

  1. #1
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    362
    Location

    Bug? with activeX combobox

    Hi all,

    I've got a workbook (xlsb) with a couple of form controls, two images with attached macros and a combobox
    the combobox regularly fails to operate, and throws a second image of itself a little distance away if it is clicked - and otherwise fails to do anything.
    I've deleted and replaced it - and get exactly the same result.

    ActiveX bug.jpg

    I run Win10, office 365 (64 bit) and found this problem after migrating to a new laptop (prev lappy was running the same config), and getting windows and office updates - though am not sure if this is connected or not.

    when I was adding the replacement cmb, I added the new one first, typed in the config, and had both cmb's working. I deleted the old one, added data to a table, and found the new cmb acting the same as the old one.

    I had more issues that I fixed by adjusting trust centre settings, and now have macro and activeX security set to ask before running, and have the folders (in onedrive) set as a trusted location.

    does anyone have ideas on where this is coming from or how to beat it?
    thanks
    Werafa

    addendum:

    hmm, that is annoying.
    saved it as xlsm - it didn't work.
    closed excel, and had some document recovery stuff appear
    closed this and opened the xlsm, it didn't work.
    closed this and opened the xlsb - it started working.

    can't call this a solution though as it has 'started working' several times before
    Remember: it is the second mouse that gets the cheese.....

  2. #2
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,008
    Location
    If you scroll it off the screen, and then come back does it go away?

    Might be a video reminant??
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    362
    Location
    No, it does not fix it.

    the problem is affecting other workbooks too.
    the 'image' only appears when the control is clicked, and disappears when released.
    I just had one in which the image overlapped the control, and when I clicked the overlap, was able to trigger the combobox
    Remember: it is the second mouse that gets the cheese.....

  4. #4
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    362
    Location
    the main reason for using activeX (except for the combobox) is to be able to edit the button label via VBA.

    Am starting to wonder if I should ditch activeX entirely
    Remember: it is the second mouse that gets the cheese.....

  5. #5
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,598
    Location
    Quote Originally Posted by werafa View Post
    Am starting to wonder if I should ditch activeX entirely
    Yes, if at all possible. They are unreliable.
    Be as you wish to seem

  6. #6
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    362
    Location
    Oh dear.

    ah well, Murphy's Law of Combat:
    1: Friendly fire isn't
    2: incoming fire has right of way
    3: Your weapon was made by the lowest bidder
    Remember: it is the second mouse that gets the cheese.....

  7. #7
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    345
    Location
    Quote Originally Posted by Aflatoon View Post
    Yes, if at all possible. They are unreliable.
    I confirm.
    ActiveX controls placed on a worksheet often make different pranks.
    Use the ComboBox from the form controls group.


    Artik

  8. #8
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    362
    Location
    and 4: never interrupt the enemy when he is doing something stupid...

    Thanks for the interruption. The workbook is not as elegant - but working is better than pretty methinks.
    1 down and 1 to go. As you can probably see from the incoherent rambling, I'm near laugh or cry stage over this
    Remember: it is the second mouse that gets the cheese.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •