Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I do it??? (OnAction with CommandButton)
Hy all,
in the FIRST page of a MultiPage control, I'd like to add some buttons... So, using following lines of code: Set MyButton(i) = ParamMultiPage.Pages("FIRST").frameREAD.Add("Forms .CommandButton.1") MyButton(i).top = ... ecc ecc. MyButton(i).left = ... ecc. ecc. inside a 'for' loop, I make a lot of buttons (that doesn't work!) So, after SET, I wrote: MyButton(i).OnAction = "CippaLippa" I expect that at every click on a button, function CippaLippa occur... System tolds me that the object doesn't support the action. GRRRRRRRR! Why? In reality (but this is science fiction!) I'd like CippaLippa to receive ID of pressed button with something like: MyButton(i).OnAction = "CippaLippa(" & i &")" First (simple?) call doesn't works... Second neither! ____ANSWER 2___ Is there a way to convert my .xls application file to something like exe? Something that doesn't need Excel to work. Cells, graphic functions and so on... I don't expect someone write me how, a link to one or (better) more documents will be sufficient! THANKS IN ADVANCE! Gianmarco. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnAction procedure | Excel Programming | |||
OnAction Variables | Excel Programming | |||
.OnAction with arguments | Excel Programming | |||
OnAction | Excel Programming | |||
OnAction | Excel Programming |