Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do...Loop syntax help? | Excel Programming | |||
Simple CountA syntax (VBA) | Excel Programming | |||
loop syntax | Excel Programming | |||
Syntax error (simple) | Excel Programming | |||
need help with simple syntax error | Excel Programming |