Input Box must be integer, Cancel button type mismatch

Hello,

I am fairly new to coding so may not be aware of an easier way to do this, but the gist of my problem is that I am trying to have the user input an integer that I have declared as an integer x. Everything works fine if the user inputs an integer but in the case where they put in anything but an integer or hit cancel you'd get a type mismatch error. I've read many threads on restricting a user to integer entry but haven't found anything that solves the cancel problem, as on cancel it returns FALSE and gives a type mismatch error. So now I have resorted to pulling my hair out, as this is for now only being used by me but I'd like to make this macro easy to use for the average user. Any help would be greatly appreciated. I'll include some sample code from the Sub to let you know exactly what I am dealing with.

Please Login or Register  to view this content.

Nick

shg that worked perfectly! I had actually forgot about the type selection, as I haven't used it before. I'm glad this was a simple fix and greatly appreciate your prompt response! Thanks a bunch