ListBox Numbers Column Alignment

    Re: ListBox Numbers Column Alignment


    Hi Mike,


    Sorry for the delay, I couldn't notice we have moved to page 3 almost.


    Yes, When I click Show Demo, I receive Compile Error: Variable Not Defined and the below piece of code is highlighted:


    Code
    xlrgbPaleTurquoise


    in Sub PositionPointer(Optional colIndex As Long = -2)


    Can't wait to see the new features you were talking about: differential column formatting, visible grid lines, variable row heights, long list items that wrap rather than disappear off the side :)


    Also, another general thing I notcied, when we click on any UserForm, which has a ListBox on it, and move it around, you see strange flickering on the data in ListBox. Is it natural on VBA UFs and ListBoxes ?


    Thanks :)


    Re: ListBox Numbers Column Alignment


    That is a built in xlRGBColor constant. At least in Excel 2011. It may have been depreciated in other versions.


    replace that with RGB(175, 238, 238)


    (And leave your Option Explicit :)

    Bonjour,

    Comment aligner les nombres à droite de la 3e colonne de ma listbox?

    Merci de votre aide

    Philippe Gonin



    Bonjour,

    Comment aligner les nombres à droites de la 3ᵉ colonne de ma listbox?

    Merci pour votre aide

    Philippe Gonin

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login