View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LESLIE LESLIE is offline
external usenet poster
 
Posts: 113
Default pass parm to another userform

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?