Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parameters in Forms Buttons - not working in Excel 2002
In Excel 2003 and 2007, I can create buttons from the Forms toolbar
(in Excel 2007, from "Forms Controls") and assign parameters to them, like this: Sub test_button(arg) MsgBox arg End Sub Assign Macro | Macro Name: 'My Workbook.XLS'!'test_button(5)' '(note that the single quotes around testbutton(5) are required.) Works fine in Excel 2003 and 2007. But in Excel 2002, nothing happens when I click the button. Was the ability to send parameters from Forms buttons new in Excel 2003, or is there something different I need to do to get it to work in Excel 2002? Thanks, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to sum up base on date parameters ? | Excel Discussion (Misc queries) | |||
Option Buttons from the Forms Toolbar - Excel 2003 | Excel Worksheet Functions | |||
Data Forms in Excel 2002 | Setting up and Configuration of Excel | |||
How to create a shortcut key to access buttons in excel forms | Excel Programming | |||
MDI Forms in Excel 2002 XP | Excel Programming |