Forum Discussion
cksmy
May 09, 2022Copper Contributor
Need help with an ActiveX TextBox
Can anyone give me advice as to how I would stop my ActiveX TextBox from resizing the font inside the box every time I click outside of the box and back inside the box? The TextBox border also appear...
HansVogelaar
May 09, 2022MVP
I don't have a clue why that happens, but I wonder why you're using a text box. Why not let the user enter the search term in a cell? You can use the Worksheet_Change event procedure to handle changes in the cell.