Visibility Based On Value Of Multiple Column ListBox

Re: Command Button Visibility Based On Value Of Multiple Column ListBox

Do you mean when a row is selected in the list box or just when the listbox is loaded?

What is the certain text? is it static or read from a control or cell?

Re: Command Button Visibility Based On Value Of Multiple Column ListBox

I'd just have something like the below on the listbox change event

Assuming your userform is called UserForm1, your Command Button to be hidden is called CommandButton1 and the List Box is called ListBox1;

Private Sub ListBox1_Change()
Dim a As Integer
Dim WantedString As String


WantedString = "Value you want in column 4"


UserForm1.CommandButton1.Visible = False


With UserForm1


For a = 0 To .ListBox1.ListCount - 1
If .ListBox1.List(a, 3) = WantedString Then .CommandButton1.Visible = True
Next a


End With
End Sub

Hope that's some use,
Ian

Re: Command Button Visibility Based On Value Of Multiple Column ListBox

Ian, consider;

CommandButton1.Visible=(.ListBox1.List(a, 3) = WantedString)

Re: Visibility Based On Value Of Multiple Column ListBox

Dave - doing it your way, if I am loo'ping for a, would make the box visible if column 4 had the right string in it, but then not visible for the next a if that column 4 didn't have the wantedstring in it, which is why I used an 'IF'.

Doing it your way (unless I've misunderstood) would result in the CommandButton showing only if the last row in the list box had the wanted string in column 4 whereas jamierodgers has asked for the button to be vivsible if the string appears in any row of column 4.

Did I misunderstand your post?
Ian

Re: Visibility Based On Value Of Multiple Column ListBox

Need loop?

Private Sub ListBox1_Click() 
    Dim WantedString As String 
     
    WantedString = "Value you want in column 4" 
     
    UserForm1.CommandButton1.Visible = False 
     
    With UserForm1.ListBox1
         
        UserForm1.CommandButton1.Visible = (.List(.ListIndex,3) =  WantedString)
         
    End With 
End Sub

Re: Visibility Based On Value Of Multiple Column ListBox

Ian, I don't know if the way I show fits the OP needs or not. Andy asked him/her some vital questions, but no answer.

Re: Visibility Based On Value Of Multiple Column ListBox

Better late than never