passing parameters

Private Sub Game_Num_Val_Change() Dim cntl As Control Me.Game_Num_Val = UCase(Me.Game_Num_Val) Set cntl = Me.Game_Num_Val Call VerticalAlignCenter(cntl) End Sub Public Sub VerticalAlignCenter(ByRef ctl As Control) MsgBox 1 On Error GoTo ErrorCode Dim MinimumMargin As Integer Dim...

I have a routine that counts variables but I have to pass a string so it knows which one to test. There has to be a better way. Private Function ArrayVariableCount(Arr As String) Dim nonEmptyElements As Integer, i As Integer ' nonEmptyElements = 0: i = 0...

Hello, I have a question on how to remember or pass the place where the user doubleclicks. I am trying to make a form show up when a certain range is chosen. For now this range is static, but it will be dynamic in the future. Once the user double clicksa cell in this range, the form pops up...

Please let me know if there is a way to pass parameters from a double click event to a user form event. I tried defining an integer as public in module 4 but I cannot see it in userform2 if I set it to 1 in Sheet1 (where my double click event is). Thanks for the help...