Simple Macro - Change Cell

[fedas18]

Hi,

I am trying to write a macro (with a botton) that will change cell K3 to 1.

Any help?

Idk if its possible but if my botton could change K3 to 1 then back to 0 if I double click the botton that would be idea. If not no big deal.

Thanks!

 

[Joe4]

Here is a simple little macro that will toggle the value of B3 between 1 and 0 whenever it is run.

Sub UpdateK3()
 
    If Range("K3").Value <> 1 Then
        Range("K3").Value = 1
    Else
        Range("K3").Value = 0
    End If
        
End Sub

Check out this link to see how you can create a button and attach that code to the button:
http://www.wikihow.com/Create-a-Custom-Macro-Button-in-Excel

 

[fedas18]

You the man!

Thank you so much

 

[fedas18]

Quick question. What does <> do?

Thanks!

 

[Joe4]

"<>" means "not equal to" (quite literally it means "greater than or less than").

So we are saying if K3 does not equal one when the button is pushed, set it equal to one. Otherwise, set it equal to zero.

 

[fedas18]

much appreciation

boss loved it