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
|