What button type[listbox or command?] and what script do I attach to a
button I've called 'Select a Workgroup' which, when clicked on, will provide
a drop down box with all workgroup names. I would like to be able to click
on a name and have the data within the report reflect that of the workgroup
selected. I'm trying to recreate a macro button in Excel as used in Lotus -
example below :

Sub Click(Source As Buttoncontrol)
[/w].MacroRun
End Sub

*where /w represents "workgroup"

Does Excel have the same premise as Lotus whereby a "workgrouplist" and
"workgrouppick" need to be named in a range as well as the following
formula{CHOOSE-ITEM workgrouplist;workgrouppick;"Select a
Workgroup";"Workgroup Selection"}{calc}. Is there a web site that I can
refer to for assistance?
Thank you!