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. You can use the alignment tools to make everything look professional with even spacing. Your mouse should now look like cross hairs and you will just want to click somewhere on your spreadsheet to draw the Option ButtonĪfter you draw a couple of Option Buttons, you can drag them into place so that they are relatively close to your search box.Select the Option Button Form Control (first row, last icon).Click the Insert drop down button in the Controls group.
0 Comments
Leave a Reply. |