I have a problem with this what am I doing wrong?
I have attached a simple example the result I was looking for was when command button is clicked the textbox would be cleared of text.
Textbox1 = ""
It has worked in userforms before now when I try it and have the textbox in a worksheet it doesnt seem to work?
any ideas?
Its because you've placed the code in a code module and it doesn't know which textbox. Maybe
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Because your text box is in a worksheet and not a form, you need to insert the sheet reference
Please Login or Register to view this content.
Edit: got sidetracked and solus gave you the answer. Good.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Re: clear text from textbox's
ah right got it!
Thanks!
Glad to help. If you're satisfied with the solution please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks