The site formerly known as Code For Excel and Outlook
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.
Continue Reading: Validating 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.
Continue Reading: Restricting character input in a textbox on a userform »
August 24, 2010 by · 
In Add Data Validation to any worksheet using VBA I demonstrated a technique for … adding data validation to any range. Surprise! 
Now we'll try and do something with those data validation ranges. What I'd like to do is select a cell that has data validation on it and return the list of valid members (assuming that the source data is a Range or name that refers to a Range).
Continue Reading: Get Data Validation Range »
February 22, 2010 by · I found another website that lists web services you can consume in your VBA applications. WebserviceX.net
provides On Demand XML Web Services for Financial,Distribution, Retail, Health Care, Manufacturing, Telecom, Government and Educational Industry.
What this means for you is more stuff to do. Well, more stuff for your applications to do.
Continue Reading: Email validation in VBA »
Site last updated: February 9, 2012
Follow Me