Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button caption
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button caption
On Nov 16, 1:15 pm, LesHurley
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button caption
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using vba to change command button caption | Excel Programming | |||
multi line caption on command button?? | Excel Programming | |||
changing the caption of a command button | Excel Programming | |||
Command Button Caption | Excel Programming | |||
Urgent: VBA Command Button Caption Problem | Excel Programming |