That is the syntax, just access it via

FirstFormName.r

form frmAdditionalLines

--
__________________________________
HTH

Bob

"Leslie" wrote in message
...
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?