Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Column Headings as Range (2003 SP2)

    Good evening

    I have 41 Column headings that I have saved as a range, if I use Data Validation in a cell it will display all 41 of them, if I call the range in a combo on a user form it only shows the first one

    Conditional Formating in a cell =DataValidation - displays OK
    Combo on UserForm in initialize = cboStock.List = Range("PackingMaterial").Value - only displays the first item of the range

    Any ideas what I have done wrong please

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Headings as Range (2003 SP2)

    Te combo on the userform expects the range to be vertical. You might try this:

    cboStock.List = Application.Transpose(Range("PackingMaterial").Val ue)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Headings as Range (2003 SP2)

    Thanks Jan

    That works great

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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