View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr B[_2_] Mr B[_2_] is offline
external usenet poster
 
Posts: 29
Default Need some syntax help, simple loop I think

Howdy,

I have programmed in Excel in a long time and am not sure where to begin...

I have some data in 5 column such as:
Name, City, X-coord, Y-coord, Item

I want to run through this data and create a map in the second sheet where
at the given X, Y coordinates for each person, it colors that cell a certain
color based on the "Item" and then creates a Comment for the cell containing
the Name and City.

I know this should be pretty darn easy but I'm rusty and need some guidance.
Some things I know I need a

How to set the fill color via a command.
How to insert a comment via a command.
Basically everything to get me started.

Thanks for any and allhelp.