View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Toolbar Button Coordinates

http://www.cpearson.com/excel/FormPosition.htm

that is for a cell, but the button has a cell under it (topleftcell
attribue).

--
Regards,
Tom Ogilvy


"Zone" wrote in message
...
My custom toolbar has a button that brings up a userform. I want the
userform to be centered horizontally over the button. Thing is, the
toolbar may be moved around or be displayed on PCs with widescreen
monitors, etc. How do I determine how to center the userform over the
button? TIA, James