Results 1 to 5 of 5

Thread: [RESOLVED] Headers in multicolumn listbox

  1. Jan 31st, 2007, 03:42 PM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Resolved [RESOLVED] Headers in multicolumn listbox

    For a multicolumn listbox located in a sheet, how can I specify the name to appear in the column's head?
    If it was located in a userform, one could use the .RowSource property, but this property doesn't exist when located in a sheet...
    Extra question. Is it possible to change the colour of a single column?
    Last edited by Fonty; Feb 7th, 2007 at 01:32 PM.
    Reply With Quote Reply With Quote
  2. Jan 31st, 2007, 05:39 PM #2
    Siddharth Rout
    Siddharth Rout is offline
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Headers in multicolumn listbox

    how can I specify the name to appear in the column's head?
    Right click on the listbox and change the
    .ColumnHeads = True
    .ListFillRange = Sheet1!A1:C4 'say this is the range

    Extra question. Is it possible to change the colour of a single column?
    Hmmm... not sure about this...

    Hope this helps...
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero
    Reply With Quote Reply With Quote
  3. Feb 1st, 2007, 09:06 PM #3
    dmaruca
    dmaruca is offline
    Fanatic Member dmaruca's Avatar
    Join Date
    May 2006
    Location
    Jacksonville, FL
    Posts
    577

    Re: Headers in multicolumn listbox

    Quote Originally Posted by Fonty
    Extra question. Is it possible to change the colour of a single column?
    Do you mean like right-clicking the column letter, selecting format cells and going to the patterns tab?
    Reply With Quote Reply With Quote
  4. Feb 2nd, 2007, 02:45 PM #4
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Re: Headers in multicolumn listbox

    I mean that the specific column appears in a different colour than plain white.
    Reply With Quote Reply With Quote
  6. Feb 2nd, 2007, 02:53 PM #5
    dmaruca
    dmaruca is offline
    Fanatic Member dmaruca's Avatar
    Join Date
    May 2006
    Location
    Jacksonville, FL
    Posts
    577

    Re: Headers in multicolumn listbox

    Oh, duh. This is about listboxes. No, I'm not sure that you can.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width