Custom Office Programming and Automation
Hope you got everything you wanted for the holidays!
In Restricting character input in a textbox on a userform I complained about inline textbox validation. So I feel compelled to produce some sample procedures that illustrate what I see as a better way to validate userform data.
One of my pet peeves is intrusive VBA code that interrupts workflow. The problem usually goes something like this:
I have an application/workbook that relies on certain user input data. I have a textbox/cell and I only want certain characters to be allowed. (list of characters follows) How can I accomplish this?
The answer usually involves some version of Worksheet_Change or KeyPress events that detect the input characters and act accordingly.
Sorry for the lack of posts lately. School and family have been taking up most of my time. I did manage to work on a few things:
I'll post them as soon as I can.
Thanks,
Jimmy
If you're like me, stuck at work while the World Cup rages, you might still be lucky enough to be able to visit FIFA.com and watch the play-by-play. I'm not a big soccer fan but I depend on the realtime play-by-play to tell me what's happening during the game.
You might have also noticed those cool country flags on FIFA's website.
Fortunately, they are downloadable for use in your Excel worksheets and VBA programs. Let's build a small app to display and save them.
Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Legal
Follow Me