Actually, what I meant was...
can I use a for i=1 to 4

togglebutton(i)

cell(Ai)="Something"
next i

thanks

"Nelson" wrote:

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
----
case is 2
---
and so on?

Thank you in advance.