Sorry - rubbish title.
I'm looking for some advice. I have 50 Textboxes on a userform and I wish to prevent a user from entering info in each one that begins with an 'I'. My code works fine but naturally I don't wish to have it repeated 50 times. How would I incorporate it into a loop and what would I call the Sub?
Please Login or Register to view this content.
You can do whats called event sinking, how are you with VBA?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hi Nathan,
Out of 10? Probably a 5.
Six on a good day!
Ok, i'll tell you what to do and send a sample.
You need the following in your userform
Then you need a class, called clsCustomTextBox, which has the codePlease Login or Register to view this content.
What this does is pass every textbox on the form initialisation and diverts it to be our customtextbox, which is inherited from MsForms.Textbox, we just mess about with the events.Please Login or Register to view this content.
HTH
I see, thank you very much.
I have a few questions if I may?
- The class part. I have inserted a class module – is this what you mean?
- Will your code apply to all textboxes? I have other textboxes where it’ll be ok for the user to start their TB entry with ‘I’. Although the ones I want it to apply to all share a similar naming pattern – could I use that? So instead of:
Could I use:Please Login or Register to view this content.
Please Login or Register to view this content.
- Lastly I receive the following error upon compile (user type not defined):
Please Login or Register to view this content.
1 Yes it does, you will need to put after the if Typename line,this will then omit the sinking for control1 and control2. Typename is the type name not the name.Please Login or Register to view this content.
2 Have you named your class clsCustomTextbox?
That's great. Thanks a lot Nathan!! : )
You could put this event code in the class module
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks