InputBoxes and Variables
Posted on 2008-10-25
I'm using VBA for Excel. I created 2 different variables, vntMonth as a variant and intMonth as an integer. I assigned vntMonth to an inputbox for a user to enter a month. I wanted this to be an integer so i ran it through error-checking using the IsInteger function and If-Else statements. Now I'd like to store this validated version of vntMonth as an integer, therefore using the variable intMonth. How do I do this? What code would I write?