I have a command button on a worksheet with a CLICK event handler. Is it
possible to toggle the caption on the button between say, Set , Reset with
each click?
--
Thanks

On Nov 16, 1:15 pm, LesHurley <LesHur...@discussions.microsoft.com>
wrote:
> I have a command button on a worksheet with a CLICK event handler. Is it
> possible to toggle the caption on the button between say, Set , Reset with
> each click?
> --
> Thanks

Yes it is possible, I've just quickly made a userform to do this.
Could you provide more detail? Why you would want to do this, as it
looks a bit confusing to me, not least to your users. Is the button
running the same code with each click or different code?

Dave

Public Sub Test()
With ActiveSheet.Buttons("Button 1")
If .Caption = "Set" Then
.Caption = "Reset"
Else
.Caption = "Set"
End If
End With
End Sub


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LesHurley" <(E-Mail Removed)> wrote in message
news:5C613146-DF2F-4348-9C64-(E-Mail Removed)...
>I have a command button on a worksheet with a CLICK event handler. Is it
> possible to toggle the caption on the button between say, Set , Reset with
> each click?
> --
> Thanks