Is this possible to do in Visual Basic?
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?
Composing members: 0