Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: can some1 just help me out with this please please pls???

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

    Default

    Did you create the ComboBox using View|Toolbars|Forms?

    Yes

    If so, what is its input range and cell link?

    Input range is just saying select list AAA or BBB to be appeared to the list box.

    Does the input range of your combobox contain the list names AAA and BBB?

    yeah!

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

    Default

    why is my post disappearing???


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

    Default

    ok, i got two ranges. named AAA and BBB

    in cell A1 i got a number which is either 1 or 2 controlled by a combo box.

    i have got a list box that will show list AAA when the number in cell A1 is 1, and show list BBB when the number in cell a1 is 2. how can i do that???

    pls help

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

    Default

    pls remember that both range AAA and BBB are already using =offset() stuff, so...

    pls help!

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,613
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-14 10:27, LMF wrote:
    pls remember that both range AAA and BBB are already using =offset() stuff, so...

    pls help!
    Did you create the ComboBox using View|Toolbars|Forms?
    If so, what is its input range and cell link?

    Does the input range of your combobox contain the list names AAA and BBB?

    Aladin

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Oops! I misread your post and started on this with option boxes on the userform. Please change the references to the cell A1 value.

    Here, the option box determines which range appears in the ListBox.

    Private Sub OptionButton1_Click()
    Dim AAAItem, Alist
    UserForm1.ListBox1.Clear
    Set Alist = Sheets("Sheet1").Range("AAA")
    For Each AAAItem In Alist
    UserForm1.ListBox1.AddItem AAAItem
    Next AAAItem
    End Sub

    Private Sub OptionButton2_Click()
    Dim BBBItem, Blist
    UserForm1.ListBox1.Clear
    Set Blist = Sheets("Sheet1").Range("BBB")
    For Each BBBItem In Blist
    UserForm1.ListBox1.AddItem BBBItem
    Next BBBItem
    End Sub

    This should get you started. Please post back if you need more details with your particular setup.

    Bye,
    Jay

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,613
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-01-14 12:33, LMF wrote:
    Did you create the ComboBox using View|Toolbars|Forms?

    Yes

    If so, what is its input range and cell link?

    Input range is just saying select list AAA or BBB to be appeared to the list box.

    Does the input range of your combobox contain the list names AAA and BBB?

    yeah!
    I wished I had more specific answers to the above questions. What follows will describe how to connect a combobox with a listbox.

    We have a range (preferably in a worksheet called Admin), which is named CList, housing the following items:

    AAA
    BBB

    Again, we have in Admin two ranges which are named AAA and BBB.

    In a worksheet, named say Main, create a combobox, using the option View|Toolbars|Forms in B2, with CList as Input range and with B2 as Cell link.

    Activate the option Insert|Define|Name.
    Enter CurList as name in the Names in Worbook box.
    Enter as formula in the Refers to box:

    =INDIRECT(INDEX(CList,Admin!$B$2))

    Activate OK.

    Create a listbox in E2 in Main, using the option View|Toolbars|Forms, with CurList as Input range, with E2 as Cell link, and Selection type set to Single.

    That's all.

    Aladin

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
  •