• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

InputBoxes and Variables

Hi,

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?
0
azmeen123
Asked:
azmeen123
1 Solution
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
If you have validated vntMonth already, then:

    Dim vntMonth As String
    Dim intMonth As Integer
    ...
    intMonth = CInt(vntMonth)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now