Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    fiil list box based chkbox (2000 sr 1)

    have this userform with litsbox and chkbox...
    How to fill listbox with value of sheet DEP_B(column G) if the chkbox is cheked, inested if check box is check fil listbox with value of sheet STORICO(column G)...of coiurse fill listbox without blank cells...
    Tks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: fiil list box based chkbox (2000 sr 1)

    In your description, the check box should be checked for both options, that cannot be correct.

    You already know how to fill a combo box from a range. You can add an If ... Then ... Else statement to test the value of the check box:

    If Me.CheckBox1 = True Then
    ' code to fill combo box from one of the sheets
    Else
    ' code to fill combo box from the other sheet
    End If

Posting Permissions

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