Send to a Friend

Sinxposed's avatar

Is this possible to do in Visual Basic?

Asked by Sinxposed (11points) November 14th, 2009

Ok. I’m going to try to explain this the best that i can.

I have an excel 2007 spreadsheet, Column A is a list of Names, Column B is their X coordinate, Column C is their Y coordinate. (simple coordinates, from 1 to 125, whole numbers only)..

I do not like the scatter map in excel, i need something better.

My idea is to make a VB program, so i can load the excel file, and then have it use, say sheet2, to plot those points accordingly, and by plotting all i would want to do is change the cell color to red or something, so when i zoom out, i can see it easily. I would also like to have it automatically insert a comment, with the info from Column A into it.

I’m not sure the best way to go about this, if VB is even the best way. I really just need a program that will take excel info and put it into a scatter map that is better than what comes with excel.

Any ideas, is it possible, is that the hard way?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.