+ Reply to Thread
Results 1 to 2 of 2

Listbox problem - dont display properly

Hybrid View

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Lima,Peru
    MS-Off Ver
    2016
    Posts
    25

    Listbox problem - dont display properly

    Hello Master of Macros.
    I need your expertise
    I have problems with LISTBOXs, each time that I close the excel file and open again
    the listboxes appear unconfigured... I dont understand why happen that and how fix it.

    I am using this code:

    Sub ListBox9_Click()
    
    ListBox9.AutoLoad = True
    ListBox9.BackColor = RGB(255, 102, 0)
    ListBox9.ForeColor = RGB(255, 255, 255)
    ListBox9.Width = 90
    ListBox9.Left = 171
    
    
    End Sub
    Maybe there is a way to keep listboxs in a constant position.
    I am attaching the excel file for you can check.

    Thanks for your valuable advice.
    I am learning so much from this forum.CALENDARIO - 2023 - CON CODIGO COMENTARIOS.xlsm

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,849

    Re: Listbox problem - dont display properly

    This code only executes when the box is clicked. If you want these attributes set as soon as it loads you should set them in the properties list.

    Also I could not find ListBox9 on the worksheet, only ListBox2 and ListBox12. You are going to have to give more detailed information about your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Problem with display textbox when filter the data in listbox
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2015, 08:28 AM
  2. [SOLVED] Problem with display information when filter the data in listbox
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2015, 10:55 PM
  3. A few macros dont work properly with Personal.xls
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-19-2008, 06:50 AM
  4. Replies: 1
    Last Post: 01-05-2006, 12:20 PM
  5. Copy paste in excel dont work properly
    By trialproduct2004@yahoo.com in forum Excel General
    Replies: 0
    Last Post: 12-30-2005, 06:00 AM
  6. Copy paste in excel dont work properly.
    By trialproduct2004@yahoo.com in forum Excel General
    Replies: 0
    Last Post: 12-30-2005, 03:20 AM
  7. [SOLVED] Listbox data display problem
    By Henry in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-11-2005, 08:00 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