x = 304
y = 122
坐标集 = Split("95,66|110,96|133,116|159,129|198,132|243,132|279,130|304,122|321,95|346,79|367,59|379,47|367,59|346,79|321,95|304,122", "|")
aaa = 100000
临时 = ""
For Each bbb In 坐标集
XY = Split(bbb, ",")
If UBound(XY) >= 1 Then
'转化成数值
ax = CInt(XY(0))
ay = CInt(XY(1))
'计算平方
计算 = (ax - x) ^ 2 + (ay - y) ^ 2
'交换数据
If 计算 < aaa Then
aaa = 计算
临时 = bbb
End If
End If
Next
msgbox "最近坐标点:" & 临时 & ",距离平方:" & aaa