I'm looking for a VBA script that whenever I click away from any kind of ActiveX text box in the document Will do. Another option would be this whenever I click on any text box (without clicking away) to run
How can each text box be individually selected without assigning it to everyone?
Double click on your text box and it will bring the default method for that textbox, which is in my test textbox1_Change () is. This method will run every time you type something in the text box.
You will see two dropdown boxes at the top of the Viebda editor. Drop down on one on the right and you'll see all the other available methods for the textbox, one of which is a lost focus which I think is relevant to your purposes by clicking on it, which makes the text box lose focus Every time you see how you go with it Cheers
No comments:
Post a Comment