is there a way (As in vb6) to pass the x,y cordinates of where yo
pressed on a commandbutton that is on a worksheet to a variable in
macro?

I'm thinking of vb6 :
sub command_up(x,y, shift) (or something similar)
xcord= x
ycord=y
end sub

thank you. you guys are great

--
Message posted from http://www.ExcelForum.com