I want to make a variable toolbar. Sometimes there are 4 charts
possible, connected to 4 buttons. Sometimes 2 or 3.
Here my code
For iCH = 1 To numCHARTS
onAct = "MAKEchart" & iCH
'??????? how to do this ??????
'??Set MyButtonCHART & iCH ?? =
Controls.Add(Type:=msoControlButton)
With MyButtonvarCHART & iCH ...???
Caption = "chart" & iCH
Style = msoButtonCaption
BeginGroup = True
'.OnAction = onAct
End With
Next iCH
Some help is always welcome. Thx
Zurn
--
Zurn
------------------------------------------------------------------------
Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
View this thread:
http://www.excelforum.com/showthread...hreadid=526740