Switch array. Consider the following worksheet that shows four buttons arranged in a switch array. Compose a VBA Macro for each button that inserts the binary row address in E2 and the binary column address in F2.

Question

Answer 1

Sub Button1()
Range("E2").Value = 0
Range("F2").Value = 0
End Sub

Sub Button2()
Range("E2").Value = 0
Range("F2").Value = 1
End Sub

Sub Button3()
Range("E2").Value = 1
Range("F2").Value = 0
End Sub

Sub Button4()
Range("E2").Value = 1 Range("F2").Value = 1
End Sub