jefferson

That worked perfectly, thanks man. I had to modify it a bit for my purposes but i never would have figured it out if not for your help. I also used a modified version of yours to ensure that a valid "range" was entered. Very helpful. Also gave me some more insight as to what you can do with ME.

Is there any way to get ME to scan a text variable looking for any occurence of a number of characters? Im trying to get macro express to return a meaningful error and allow a retry if anything other than a range of numbers, seperated by a hyphen, is typed in. I dont really want to write 50 repeating if statements. "If contains" as far as i can tell will only accept one character at a time, unless youre looking for an entire string. Basically i want the user to be able to enter 1-10 or 2005-5000, but the macro would reject an entry of 1-m or 2-!0 and then prompt the user to re-enter the variable.