Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: A really dumb question about combo boxes

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Tennessee
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi All:

    This shouldn't be this hard to figure out (I must be having a bad hair day).

    How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

    It seems that no matter what I try I can't make the combo box list the data I need.

    Thanks

    Dave

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,074
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-20 07:10, Dave wrote:
    Hi All:

    This shouldn't be this hard to figure out (I must be having a bad hair day).

    How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

    It seems that no matter what I try I can't make the combo box list the data I need.

    Thanks

    Dave
    Use the Search facility if this board with combo to find a few threads where I describe how it's done using View|Toolbars|Forms.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-20 07:10, Dave wrote:
    Hi All:

    This shouldn't be this hard to figure out (I must be having a bad hair day).

    How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

    It seems that no matter what I try I can't make the combo box list the data I need.

    Thanks

    Dave

    Goto Insert>Name>Define
    Type something like D_List
    in the Refers to box type:

    =OFFSET(Lists!$A$2,0,0,COUNTA(Lists!$A:$A)-1)

    in the Visual Basic Editor bring up the Properties box
    Highlight the Combobox
    In the RowSource in the proporties and type =D_List
    "Have a good time......all the time"
    Ian Mac

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Tennessee
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi:

    Thanks for the input! Works the way it should now.....Talk about making a guy feel stupid...

    Thanks

    Dave

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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