Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OnAction procedure Max Potters Excel Programming 4 September 26th 04 07:58 PM
OnAction Variables Howiee22 Excel Programming 1 August 22nd 04 02:53 AM
.OnAction with arguments max Excel Programming 4 February 23rd 04 06:30 PM
OnAction Jim Rech Excel Programming 1 September 5th 03 04:39 PM
OnAction Richard Yang Excel Programming 1 July 15th 03 01:37 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"