L
Leslie
I am new to excel programming and stuggling to come up with the proper syntax
for passing my rownumber to another userform.
I have one user form where I have code for navigating through the rows on my
spreadsheet. I have a button on my main form called "Additional Lines".
When this button is clicked, I have the following code.
These variable are declared up top:
Public myrow as Variant
Public r as Long
Private Sub cmdAdditionalLines()
myrow = r
frmAdditionalLines.show vbModal
End Sub
Does anyone know what the syntax is pass "myrow" parm and show user form?
for passing my rownumber to another userform.
I have one user form where I have code for navigating through the rows on my
spreadsheet. I have a button on my main form called "Additional Lines".
When this button is clicked, I have the following code.
These variable are declared up top:
Public myrow as Variant
Public r as Long
Private Sub cmdAdditionalLines()
myrow = r
frmAdditionalLines.show vbModal
End Sub
Does anyone know what the syntax is pass "myrow" parm and show user form?