Anybody use VBA?

[mcecm]

Using VB in excel, I have to draw a line between a random point and the closest point on a polygon. I've got the random point and the polygon but can't figure out the code to calculate the closest point. Can anyone help?