Rereading your original question again more carefully, it seems that you
want all the labels to be flat except for the currently selected one which
should be yellow & sunken.
If that is the case, then all you need to do on receiving a Click event is
to set *all* the labels to be flat, and then change the settings of just the
selected one.
You can iterate through all the labels in a UserForm like this, before
setting the one you want to be yellow and sunken.
Private Sub mShapeSelectNew_Click()
Dim oControl as Control
For Each oControl in mShapeSelectNew.Parent.Controls
If TypeOf oControl is MSForms.Label Then
oControl.BackColor = vbButtonFace
oControl.SpecialEffect = fmSpecialEffectFlat
End If
Next oControl
With mShapeSelectNew
.BackColor = vbYellow
.SpecialEffect = fmSpecialEffectSunken
End With
End Sub

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
> Hi Jonathan,
>
[quoted text clipped - 119 lines]
>> >
>> > Jerry Bodoff
Jerry Bodoff - 09 Nov 2004 09:08 GMT
Hi Jonathan,
Fantastic! It works like a charm. I was having trouble because I never used
the "Parent" property before and I did not know how to get to all the labels.
I learned something new.
I will post my Outlook question in the Outlook news group. Using the web and
having to sign in to Passport is a real pain. Besides which, the web page
text is too small. I really liked the old way (I think it was more "user
friendly").
Thanks for all your help. I really appreciated it.
Jerry Bodoff
> Rereading your original question again more carefully, it seems that you
> want all the labels to be flat except for the currently selected one which
[quoted text clipped - 145 lines]
> >> >
> >> > Jerry Bodoff
Jonathan West - 09 Nov 2004 12:58 GMT
> Hi Jonathan,
>
[quoted text clipped - 9 lines]
> text is too small. I really liked the old way (I think it was more "user
> friendly").
Make sure you post to an Outlook Express group rather than an Outlook group.
They are two completely different programs, and Outlook does not do news.
Also, this website may be helpfil to you: http://insideoe.tomsterdam.com/

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
JBNewsGroup - 11 Nov 2004 06:47 GMT
Hi Jonathan,
Last post in this thread.
I finally got Outlook Express fixed, was set for sending HTML and not plain
text.
Regarding sending the clicked label data to the macro. I created 2 Property
Set's for setting a pointer to a dummy hidden label on the user form and to
set a pointer to an control which is to receive focus after clicking a
label. The class module copies the relevant clicked label data to the form
hidden label and then sets focus to the defined control. It works great.
Thanks for all your help.
Jerry Bodoff
> > Hi Jonathan,
> >
[quoted text clipped - 14 lines]
>
> Also, this website may be helpfil to you: http://insideoe.tomsterdam.com/