+ Reply to Thread
Results 1 to 6 of 6

Strange floating combo box

Hybrid View

  1. #1
    Registered User
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    MS365 Version 2301
    Posts
    68

    Strange floating combo box

    Hello,

    i have a combo box which stays in place on the sheet it does not move but after i enter a search term inside the combo and hit the search button the filter works perfectly but when i scroll around the sheet another combo box floats around the screen,

    See attached image, this is really strange.

    Thanks for looking.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    1,028

    Re: Strange floating combo box

    Could you attach your workbook (without sensitive data)?

  3. #3
    Registered User
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    MS365 Version 2301
    Posts
    68

    Re: Strange floating combo box

    Attached sheet,

    If you search anything in the search box and click on the button 'search group' the filter is applied but when you scroll up or down or left and right the strange new combo box appears.

    Thank you.

    Sorry the attachment was too big so have uploaded it as a binary file please convert to .xlsm for the issue to be shown.
    Attached Files Attached Files
    Last edited by lee2121; 10-30-2019 at 05:25 AM. Reason: attachment not attached!

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Strange floating combo box

    It works fine for me, however, ActiveX controls on worksheets are notoriously buggy and are best avoided. The type of problem you're describing is typically related to one (or more) of the following:

    - Opening the workbook over terminal services/remote desktop or in a virtual machine
    - An external monitor with a different resolution to the main display
    - An external monitor with a different zoom level than another display

    As you can see, they're usually related to displays and how Excel works out the zooming/resolution of the workbook - are any of these true, or do you have a similar set up?

  5. #5
    Registered User
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    MS365 Version 2301
    Posts
    68

    Re: Strange floating combo box

    I'm opening the file from a network on a laptop with another screen so yes this fits with what your saying, i will save the file to the laptop and try it with no other screen.

    Thanks

  6. #6
    Registered User
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    MS365 Version 2301
    Posts
    68

    Re: Strange floating combo box

    **SOLVED**

    When i open the file locally even with my extra monitor the issue has now gone, thank you Kyle123

+ 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] Using Multiple Combo Box Values to populate a cell (Excluding blank combo boxes)
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2016, 08:38 PM
  2. [SOLVED] Using Multiple Combo Box Values to populate a cell (Excluding blank combo boxes)
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2016, 10:49 AM
  3. Using Multiple Combo Box Values to populate a cell (Excluding blank combo boxes)
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2016, 03:45 PM
  4. Replies: 19
    Last Post: 09-06-2014, 06:30 PM
  5. Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes
    By dovermac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:09 AM
  6. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  7. [SOLVED] Floating toolbar and floating comment?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 06:30 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