Particular Excel VBA question: point graphics

Some time ago I asked for help getting started in some fundamental VBA for Excel. I have fiddled with some macros for a few months now.

Many times I have found it easiest to turn the recorder on, and perform one or two operations manually. A look at the generated macro shows the keywords involved. This approach to learning does not cover everything, such as discovering how the VBA handles procedure control, such as loops. But it is quite a useful shortcut.

It is how I learned the command for drawing a line in the graphics aspect. But setting a single point is different. How can one possibly set a point manually?

So just what do I enter in a line to command, place a point, default color, at (say) 35,66?


True Blue Jack

I don’t know how to do this but I do know a couple of sites full of Excel / VB info that might be of help:

http://www.developersdex.com/vb/default.asp?p=2677&page=2

http://www.excelforum.com//forumdisplay.php?f=7

Is there such a thing as a point? And, if so, can you do this with the mouse?

Or do you really mean a small circle?

I do mean a “point” (pixel), although practically speaking it may come down to making a really small circle. For some reason I was thinking about the smllest possible rectangle, which no doubt would be square. But the Drawing Toolbar has both.


True Blue Jack