Search for item in multipage and show the item on the specific page + Collection

[alexgoaga]

Hey guys, I'm trying to create and advanced search while having a collection of items / buttons displayed on different pages from a multipage. I've extracted the bare minimum of the entire code in order to be able to share the workbook.

My problem is that i don't know how to do this idea : for example of items test 1 to....test 30 if i seach for test 6 and he is located on the second page from the multipage, the first page to dissapear / invisible and the item should become the first arranged.

Picture one with all the data , and picture 2 with the simulated result.

I've made the textbox_Change() but...now what?

Thank you for your time

[Tsjallie]

Would this piece of code for the search box take you in the direction you want?
Needs some additions.

Private Sub search_for_someone_Change()
Dim ctr As Object, btn As MSForms.CommandButton, part
'here is the problem
For Each ctr In Me.Controls 'Loop to all the controls in the form
    If TypeOf ctr Is CommandButton Then 'Check if it's a button
        Set btn = ctr
        Select Case ctr.Name
            Case "buton_office_model", "buton_executie_model"
                'Skip
            Case Else
'                Debug.Print ctr.Name & ": " & btn.Caption & " on " & ctr.Parent.Name
                part = Split(btn.Caption, ":") 'Split the name and the function
                If InStr(1, part(0), Me.search_for_someone) > 0 Or _
                    InStr(part(1), Me.search_for_someone) > 0 Then 'Check if the button matches the search criteria
                    ctr.Visible = True 'If match show the button
                Else
                    ctr.Visible = False 'If no match hide the button
                End If
        End Select
    End If
Next ctr
Set btn = Nothing

End Sub