Button enable and disable...

[Will03]

I have two buttons that I click to populate cells. Button 1 is clicked at the start of a call and button 2 when my call ends.

Private Sub CommandButton1_Click()
X = Sheets("calls").Cells(2, 3)
Sheets("calls").Cells(X, 1) = Now()
Sheets("calls").Cells(2, 3) = Sheets("calls").Cells(2, 3) + 1
End Sub

Private Sub CommandButton2_Click()
X = Sheets("calls").Cells(2, 3) - 1
Sheets("calls").Cells(X, 2) = Now()
End Sub

My issue is that button 1 can be clicked as many times as you want and what I want to do is only allow button 1 to be clicked, once button 2 has been clicked. What can I add to make this work like a toggle switch? Like press button 1 and disable it until button 2 is pressed...

[Mordred]

Why not use an actual Toggle Button?

[Mordred]

Better yet, try a spin button

[Mordred]

This is not tested but

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[abousetta]

Maybe something like this:

Please Login or Register  to view this content.

abousetta

P.S. Don't forget to use code tags...

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[Will03]

Thank you very much... Both are great options. I learned to use something else other than just the command buttons and stood with the toggle it was a better fit for what I needed but the spin option was also GREAT. THANK YOU GUYS issue SOLVED