CInt() conversion & inputbox

**dems** · 07-02-2009, 09:20 PM

Hi everybody, as i understand CInt() converts STRING variables to INTEGER variables.

I am trying to create an inputbox, with input validation. So, if the user types in an integer, it will continue to a msgbox; if they type a number in string format, as in 'two', it will convert this into an integer and again display it in a msgbox; if they press nothing a msgbox will appear telling them there is no input; and if they press cancel the programme closes. Any help would be appreciated.

Please Login or Register  to view this content.

**Trebor76** · 07-02-2009, 09:59 PM

Hi dems,

No, the CInt (VBA) function converts a value to an integer (see here for more details).

Not sure what you're trying to achieve, but I've together the following example with some notes to hopefully help you along the way:

Please Login or Register  to view this content.

HTH

Robert

**shg** · 07-03-2009, 12:01 AM

dems,

Please take a few minutes to read the forum rules, and then change your QUOTE tags to CODE tags.

**dems** · 07-03-2009, 07:35 PM

Thank you Trebor, that was very helpful! I was wondering if it was also possible to convert numbers written in letters into the equivalent positive integers and display it in the last msgbox?