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)