search functionality on User Form

Re: search functionality on User Form

Question is way too vague to be able to answer Howard. Sorry. Take a look at the possible answers section below, or attach an example stating more clearly what you need to do.

for example:
20 items to select.... is that a list box, or a combobox, or command buttons or checkboxes or option buttons.... etc. etc.
search for an item.... where... in a list box, or in a worksheet.... etc. etc.
search for open journal folder... do you have a "search box" on the user form....? How does it know to link Open Journal Folder to the "Journal" item?

Attach an example if the possible answers section dont help.

Ger

Re: search functionality on User Form

I would probably use a ListBox instead of Option Buttons. Why would you need to search for the OptionButton?

Re: search functionality on User Form

I doubt very much if VBA code checking each OptionBox would be faster than just clicking the correct one.

Re: search functionality on User Form

I would agree with Roy... probably better ways you could do this.... but if you REALLY REALLY wanted to keep going down this path then add a text box to you user form..... (name = Textbox1 by default) then put this code on the change event of the textbox...

Private Sub TextBox1_Change()


Dim ctl As Control
For Each ctl In UserForm1.Controls
Debug.Print TypeName(ctl)
    If LCase(TypeName(ctl)) = "optionbutton" Then
        If InStr(1, LCase(ctl.Caption), LCase(TextBox1.Value), vbTextCompare) > 0 Then
            ctl.Value = True
            Exit For
        End If
    End If
Next


End Sub

Its a little bit of a strange approach to designing the Userform though.

HTH
Ger