how to change a toggle button caption based on a certain cell

[excelNuts]

hello dear friends just registered in here i have a problem in excel vba
i made a user form with about 60 toggle buttons to show hide accounts in the main sheet
so my problem is i wanna make a code that if change the name of the account in the sheet the caption in the toggle button changes too any help would be much appreciated

this is the code but it doesn't work at all

Private Sub Worksheet_Activate()
ToggleButtons("ToggleButton19").Caption = Sheets("Sheet1").Range("J3")
End Sub

 

[Fluff]

Hi & welcome to the board.

Try this in the UserForm_Initialize event

ToggleButton1.Caption = Sheets("Sheet1").Range("J3").Value

 

[excelNuts]

thank you very much sir that really worked

 

[Fluff]

Glad to help & thanks for the feedback