Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button
Hello, I am trying to do the following:
When I press the command button, the statement "Market Order" appears in cell B1, however when I press it again it will remove the statement "Market Order". Sort of like an on and off switch. I have written the following so far, however I am having trouble in removing the statement when I press the command button again. Your help is appreciated Private Sub CommandButton1_Click() If CommandButton1.Value = True Then Range("B1").Value = "Market Order" Else Range("B1").Value = "" End if End Sub Thank you Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |