LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Modeste
 
Posts: n/a
Default Automatique Shape

Bonsour®,
;o))) useless experiments!!!

I challenge the do-it-yourselfers and nutcases about VBA...
(API, BdR,Xla modification ???)
Is it possible to modify the properties of the automatic shapes ?????

example:
ActiveSheet.Shapes.AddShape(msoShapeMoon, 28.5, 252 #, 81.75, 115.5).Select
Selection.ShapeRange.Adjustments.Item(1) = 0.875

in this example "Crescent of the moon"
I wish that the "adjustements.item(1)" be able to accept a value higher than
0.875
i-e has to be variable on range [ 0% to 100% ] crescent initiate to full
half-circle

thank you
@ +

FU2 microsoft.public.fr.excel

--
have a Look at french FAQ :
http://www.excelabo.net http://dj.joss.free.fr/faq.htm
http://www.faqoe.com http://faqword.free.fr
--


 
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
PRINTING AUTOMATIQUE ON HARD DISK P&B Consulting New Users to Excel 1 September 5th 05 04:32 PM
Handle on active shape and slide Hari Prasadh Charts and Charting in Excel 2 July 24th 05 04:30 PM
Determine shape name associated with a specific cell [email protected] Excel Discussion (Misc queries) 1 May 12th 05 12:49 AM
Capturing Shape Name/Text from OnAction property William Bartusek Excel Discussion (Misc queries) 3 April 12th 05 06:38 PM
changing comment indicator size or shape Mrocka Excel Worksheet Functions 1 December 13th 04 02:53 PM


All times are GMT +1. The time now is 08:26 AM.

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

About Us

"It's about Microsoft Excel"