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?
This question is in the General Section. Responses must be helpful and on-topic.