VBA Function that can Convert a String to an Integer

In a VBA project I have Sub that takes an Integer as an argument.
Where I call this function I intend to get the value of a this parameter from the Tag of a button (within the Click Event of which I will call my Sub that takes an integer as a Parameter).


Dim myInteger As Integer 

Private Sub cmdButton1_Click()

myInteger = Me.ActiveControl.Tag

‘However the above line does not work because the Tag Property of cmdButton1 is a String
‘ I am looking for a  function that will convert a String to an Int so that I can convert the String stored in the Tag of cmdButton
‘  to an Integer so that it can be put into myInteger. 
‘ Later in my Code I can the pass myIntegar to my other Sub that takes an Integer as a Parameter. 


Call MySubWhichNeedsAnInteger( myInteger)

End Sub
 

Open in new window






End Sub
LVL 1
FaheemAhmadGulAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
myInteger = CInt(Me.ActiveControl.Tag)
0
 
FaheemAhmadGulAuthor Commented:
Many thanks
0
 
Martin LissOlder than dirtCommented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.