To do this, you need to select the text box and then look at the Name Box (which is located to the left of the Formula Bar). First you will need to determine the name of the text box that is holding your search term.
#Pdf search bar code#
The key to getting this code to work well is to setup your objects (aka form controls) properly. Also, ActiveX controls can sometimes be glitchy depending on which version of Office you are using, so beware if you end up using this route. I typically go the shortcut route as I like having the ability to place my search box wherever I want on my spreadsheet. Assign a keyboard shortcut to execute the macro, alleviating the need to click the Search button.
Instead of using a form control textbox, you can use either a Cell or ActiveX Textbox to hold the search text (I have lines of code in the below VBA macros commented out that can handle these situations).There are two workarounds that I could think of: The one pitfall that I could not seem to get around is that fact that after entering in your search text, you need to click outside of the textbox before you can click on the Search button.
#Pdf search bar professional#
You can use the alignment tools to make everything look professional with even spacing.
0 kommentar(er)
