Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2002 -Userforms and macros help
hello everyone, I am a bit stumped on how to go about a particular tas
I am trying to accomplish. I have a Spreadsheet which is calle Qtrlyrpt. in it I have hundreds of formulas that all worked well when had the many data sheets in the same workbook. I then removed th sheets from the workbook and gave them individual workbook names with single worksheet in each. Each worksheet contains the exact colum headings and formats. The next step I did was change the Qtrlyrpt formulas to textstrings s I could record a macro to substitute variables for the following FILEPATH, Filename,Sheetname,and QTR used. I do not think recording macro to substitute those is difficult at all. at least on the test did. Where I am getting stumped is I want to create a user form that woul pass the substitued variables to the Change macro. any help would be appreciated. Thank you Rober -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2002 -Userforms and macros help
bump .... sorry for the bump was just curious if anyone had som
starter code I could look at to see variables being passed from listbox to a macro Thank -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Excel 2002 | Excel Worksheet Functions | |||
Userforms and Macros | Excel Discussion (Misc queries) | |||
Help for old macros with Excel 2002 | Excel Worksheet Functions | |||
Storing macros, userforms | Excel Discussion (Misc queries) | |||
Old Macros in Excel 2002 | Excel Programming |