Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pass value to excel userform - is there a constructor? how to pass | Excel Programming | |||
How to pass data from UserForm to spreadsheet | Excel Programming | |||
Pass public variable from one userform to a second... | Excel Programming | |||
can a userform pass an argument? | Excel Programming | |||
How to pass arguments from ThisWorkbook to a UserForm | Excel Programming |