I am trying to setup a macro where I can type a word into a textbox, click a button, and filter a table based on the value of the text box. The code I am using was made available on the SreadSheetGuru.
The problem I have is that I receive an error: "runtime error 80070057 - the item with the specified name wasn't found." And the VBA code highlights "mySearch = sht.Shapes("UserSearch").TextFrame.Characters.Text 'Control Form"Please Login or Register to view this content.
Bookmarks