View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Lovern Greg Lovern is offline
external usenet poster
 
Posts: 224
Default 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