Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


Drawing grid

 
Post new topic   Reply to topic     Anthony's VBA Forum Index -> Probability Distributions
View previous topic :: View next topic  
Author Message
zeeshah



Joined: 18 Feb 2005
Posts: 2
Location: malaysia

PostPosted: Fri Feb 18, 2005 7:13 am    Post subject: Drawing grid Reply with quote

I wud like to create a Grid(Section) on the map,? which will change their colour, according to risk factor., my project is basically a risk analysis one.
1.how can i import my map pic on excel sheet
2.how can i draw the sections like grids on map
3.how my VBA code seems to be?
Plz Help me.
Back to top
View user's profile Send private message
Data
Moderator
Moderator


Joined: 06 Oct 2004
Posts: 33
Location: NY

PostPosted: Fri Feb 18, 2005 1:05 pm    Post subject: Reply with quote

The easiest way is to cut each of the area on your map into pieces (image), then assign a click event to each of the images. Alternatively, you have to put the precised coordination of each of the areas on you map. I do not have the code handy, but it should be available on some Excel books - I have seen it. Personally, I think the later method is more time consuming than the former one.
_________________
Data
Knowledge is Power
Back to top
View user's profile Send private message
zeeshah



Joined: 18 Feb 2005
Posts: 2
Location: malaysia

PostPosted: Tue Feb 22, 2005 1:44 pm    Post subject: drawing grid Reply with quote

well, can u please explain, if i import the pic file in to my sheet, how the cell will be assign as my grid.
im really a scratch guy for VBA.
pls assist.

and i have to specificall mark or change the grid color occording to creterias.
like, say, the grids are drawn on a river map, i have to validate the depth on different region,so here the grid,make the grids color should be change dynamically on the river depth.
Or, plz suggest me, how we can validate the one grid as my one region and put the values on that region.

regards,
shah
Back to top
View user's profile Send private message
Guest






PostPosted: Thu Feb 24, 2005 1:51 pm    Post subject: Reply with quote

Please check this link as it might have the solution that you are looking for. There is also an example on mapping in the Step By Step Excel VBA book.

http://www.j-walk.com/ss/excel/tips/tip41.htm

Anthony
Back to top
Display posts from previous:   
Post new topic   Reply to topic     Anthony's VBA Forum Index -> Probability Distributions All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group