G
Guest
Hello,
I have multiple toggle buttons in an excel sheet that I need to generate
some behavior.
Although, they are lined up to perform identical tasks. For example,
Toggle Buttons 1, 2, 3, and 4 will modify cell A1, B1, C1 and D1.
Instead of having to create code for each individual togglebuttons, such as
sub togglebutton1_click()
----
end sub
togglebutton2_click()
----
end sub
is there any way that I can use the case function, for example
case is 1
I have multiple toggle buttons in an excel sheet that I need to generate
some behavior.
Although, they are lined up to perform identical tasks. For example,
Toggle Buttons 1, 2, 3, and 4 will modify cell A1, B1, C1 and D1.
Instead of having to create code for each individual togglebuttons, such as
sub togglebutton1_click()
----
end sub
togglebutton2_click()
----
end sub
is there any way that I can use the case function, for example
case is 1