Combobox help PLEASE - DESPARATELY NEED HELP!!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Combobox help PLEASE - DESPARATELY NEED HELP!!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way to (in a user form) have a combo box that will use values from a named range of products in a worksheet, rather than having to use the AddItem method? I need to do this cos the combobox will contain a list of products but this list will be added to and the end user of my system will not know how to use AddItem. The List items need to come from the range of cells. Please help.
    Thanks, Will

    [ This Message was edited by: willlobb on 2002-04-04 12:14 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If the Combo Box is CB1, and you want the range A24 to E29, you could put in the following in a line of code:

    CB1.RowSource = "A24:E29"

    Of course, you could assign the range to the RowSource property directly, while setting up your form.

    [ This Message was edited by: Fryer Tuck on 2002-04-04 12:36 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you sooooooo much, thats ace.
    Will

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
  •  

 

 
DMCA.com