Clear a Text Box
EE Pros,
I have attached a simple WB that has a Textbox on WS1 and a macro I tried to write to clear it and start anew. Alas, it won't clear.
Any help would be appreciated.
B.
ClearTextBox.xlsm
I have attached a simple WB that has a Textbox on WS1 and a macro I tried to write to clear it and start anew. Alas, it won't clear.
Any help would be appreciated.
B.
ClearTextBox.xlsm
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Great job guys. Both solutions work. It would be handy if you could give me a little more context around the differences in the approaches.
Much thanks!
B.
Much thanks!
B.
You're welcome B!
BTW both the solutions were exactly the same if I am not missing something hidden. :)
BTW both the solutions were exactly the same if I am not missing something hidden. :)
ASKER
One uses "me.shames" and the other says "activesheet".
B.
B.
Since the code was placed on the Worksheet module itself so Me can be used which is equivalent to Sheet1. ActiveSheet.is more generic.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
What is new in your code? :)