Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi to all
My worksheet has a button (btnShowList) that, when clicked, opens a form (frmShowList). This form also has a button (btnBuildTeamSheet) that calls a sub (BuildTeamSheet) that adds a new worksheet, formats it, adds formulas, etc. Here's my problem. I need to somehow pass the NAME of the original worksheet to the SUB that builds the new worksheet. I'm just not sure how to do this. Thks anny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating form on sheet 1 and having info move to sheet 2 | Excel Discussion (Misc queries) | |||
How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
Passing Variable from Sheet to Userform | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |