Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel Grouped Graphics Numbering in VBA

Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Excel Grouped Graphics Numbering in VBA

Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can check the name
property to see what you should do

NickHK

"Flintstone" wrote in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel Grouped Graphics Numbering in VBA

Thanks for that Nick, I'll give it a try.

I would still like to understand how the numbering system
works and how it can be controlled so if there is anyone
with references or who knows how it works I would still
like to get the info.
-----Original Message-----
Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My

Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can

check the name
property to see what you should do

NickHK

"Flintstone" wrote

in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Excel Grouped Graphics Numbering in VBA

Flintstone,
Sorry, misunderstood you, I think.

Each shape/group number is incremented by each time:
"Line 1"
"Rectangle 2"
Group 2 above "Group 3"

"Oval 4"
"Rectangle 5"
Group 2 above "Group 6"

Group 2 groups "Group 7"

Does that help ?

NickHK

"Flintstone" wrote in message
...
Thanks for that Nick, I'll give it a try.

I would still like to understand how the numbering system
works and how it can be controlled so if there is anyone
with references or who knows how it works I would still
like to get the info.
-----Original Message-----
Flintstone,
If it helps, you can this:
ActiveSheet.Pictures.Insert("C:\My

Pics\Sample.jpg").Select
Selection.Name = "picOne"
Then when looping through a collection/group, you can

check the name
property to see what you should do

NickHK

"Flintstone" wrote

in message
...
Anyone have any info or references on how group numbers
are assigned to graphics groups in VBA? Can a Programmer
control the numbers assigned to grouped graphics? How?



.



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
Excel graphics Berrybrook New Users to Excel 4 October 14th 09 04:39 PM
Excel Graphics GarageGuy Charts and Charting in Excel 1 July 13th 09 01:17 AM
Grouped Items won't Stay Grouped When Moving Object Heather02 Excel Discussion (Misc queries) 0 February 12th 09 07:08 PM
Page numbering - grouped worksheets Charlotte Howard Excel Discussion (Misc queries) 0 November 5th 07 02:32 PM
Numbering of Grouped Rows Phil Excel Discussion (Misc queries) 2 January 31st 05 11:38 PM


All times are GMT +1. The time now is 02:53 PM.

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"