Error Checking with Range cell in Userform. Thank you!

Hi, all

I am trying to build a user form to find out the customers who purchase more than $1,000 during a certain period.

The userform has two inputs:

One is to select the data range of customer information. Assume all customer information are in the cell A2: H10, how shall I write the error checking code if the user selects the range which is out of (A2:H10)? message box would be " You selection include invalid data, please check"..

The other input is called " Get data past this data", and I can enter a date in the following cell ( txtDate). Regarding the error checking, I am thinking to use IsDate() function to make sure it is a valid date. Will be there be any other error checking you will recommend?

Any help is appreciated. thank you!!!

Hi,

For your first question, VBA has built in Intersect and Union functions to compare ranges, but unfortunately does not contain a Difference function. So I am going to attempt to write one here (untested), and hopefully it will work for you...

Please Login or Register  to view this content.

You simply pass the input range into this function, and it will return TRUE if the selected range is valid, and FALSE is it is invalid. You would call this function after the range has been selected, something like this:

Please Login or Register  to view this content.

For your second question, yes I believe the IsDate() function will work just fine for you. The alternative would be to use a DatePicker so that the input can never not be a date...

I hope this helps