On Jan 17, 10:32*pm, "Jim Cone" wrote:
I think you must have left something out of your explanation.

The following two syntax forms work...
* *LaunchForm.CheckBox1.Tag
* *LaunchForm.Controls("CheckBox1").Tag

But *this fails...
* *LaunchForm.Controls.Tag
'--
Jim Cone
Portland, Oregon USAhttp://www.mediafire.com/PrimitiveSoftware
(Formats & Styles lists or removes unused styles or number formats - in the free
folder)


Jim,

can't explain it, but if I use the
"LaunchForm.Controls("CheckBox1").Tag" syntax it fails to pass the
value from the form to the module, but if I use
"LaunchForm.Controls.Tag" it works....

I'm using VBA from Excel/Powerpoint 2003, but that shouldn't matter

Art