+ Reply to Thread
Results 1 to 13 of 13

ComboBox displays random unwanted lines

  1. #1
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    ComboBox displays random unwanted lines

    I am trying to figure out why my ComboBox list keeps displaying lines. The lines have increased over use. I have tried to strip down to manually adding each list item but nothing seems to change the issue. Not sure what I am missing.
    ComboBox With Lines.pngCode for ComboBox.png

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: ComboBox displays random unwanted lines

    Hi trigirl,

    From your display I can't tell if the line is missing or if you have two months in the same cell. Try this:
    Put a "DoEvents" after each combox add line and see what happens. The DoEvents waits for an instant before adding the next item. Let us know what happens.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: ComboBox displays random unwanted lines

    Hi welcome to the forum,
    I'have no idea, doesn't happen on a Windows OS so my guess it has something to do with the MAC OS or the MAC video settings.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Hi. Thanks for the feedback. It did not seem to make a difference. I am actually not pulling the months from the spreadsheet. Just trying to load it manually when the form initializes. I can highlight and select each month independently. When researching online I have seen one line underneath the first list item in other peoples examples.
    Last edited by trigirl357; 03-17-2018 at 07:56 PM.

  5. #5
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Thank you. It's interesting. When researching online I have seen one line underneath the first ComboBox list item in other peoples examples & online tutorials.

  6. #6
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Quote Originally Posted by MarvinP View Post
    Hi trigirl,

    From your display I can't tell if the line is missing or if you have two months in the same cell. Try this:
    Put a "DoEvents" after each combox add line and see what happens. The DoEvents waits for an instant before adding the next item. Let us know what happens.
    Hi. Thanks for the feedback. It did not seem to make a difference. I am actually not pulling the months from the spreadsheet. Just trying to load it manually when the form initializes. I can highlight and select each month independently. When researching online I have seen one line underneath the first list item in other peoples examples.

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: ComboBox displays random unwanted lines

    If the DoEvents didn't make a difference and you can select each one individually, then I think it is a screen resolution problem. Can you change the resolution of your screen to see if lines come back?

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: ComboBox displays random unwanted lines

    The firsr row underlined means that the column header is set to visible and this is the first unselectable row

  9. #9
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Quote Originally Posted by Keebellah View Post
    The firsr row underlined means that the column header is set to visible and this is the first unselectable row
    Hmmm unfortunately it looks like it is set to false. I wondered if there was some random property causing it though....
    ComboBox Properties 1.pngComboBox Properties 2.png

  10. #10
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Quote Originally Posted by MarvinP View Post
    If the DoEvents didn't make a difference and you can select each one individually, then I think it is a screen resolution problem. Can you change the resolution of your screen to see if lines come back?
    No unfortunately it didn't make a difference. I have been using this Macro since December. When I started clicking on February - that is when the line appeared underneath. Strange.

  11. #11
    Registered User
    Join Date
    03-17-2018
    Location
    Texas
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: ComboBox displays random unwanted lines

    Hmmm. I just read an article on Office for Mac 2011 and it not being supported any longer my MS and is reported to not work correctly with the new OS High Sierra. I have a brand new high end Macbook Pro. So I am wondering if MarvinP and Keebellah was onto something. I am now debating whether to purchase the standalone Office for Mac 2016 (upgrade probably far out) or go Office 365 (mac version). I am not thrilled about the $99 annual fee - thoughts (Windows/Mac users)??

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: ComboBox displays random unwanted lines

    Have you asked someone else that owns a MAC to try it out for you?
    I can't help you any further, sorry for that, no MAC around here

  13. #13
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: ComboBox displays random unwanted lines

    I can test this for you later today. Can you let me know which exact build of 2011 you have? I can also check if it works properly in 2016.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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] unwanted numbered lines
    By GEGO in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-14-2012, 08:11 AM
  2. How to remove unwanted lines faster?
    By ryb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2011, 12:17 AM
  3. Unwanted Lines When Printing
    By johndohnal in forum Excel General
    Replies: 1
    Last Post: 02-17-2011, 09:23 AM
  4. Unwanted Lines When Printing
    By johndohnal in forum Excel General
    Replies: 0
    Last Post: 02-17-2011, 09:16 AM
  5. Replies: 3
    Last Post: 01-09-2011, 08:35 PM
  6. removing unwanted duplicate lines
    By dperry in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2009, 12:11 AM
  7. Excel displays dotted lines.
    By kish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2006, 01:37 PM
  8. unwanted graphics (horizontal lines)
    By Cardinal in forum Excel General
    Replies: 4
    Last Post: 11-22-2005, 07: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