Userform Screen Location

[Don A.]

I'm trying to place a userform in the window based upon
the location of the workbook. The top, left properties of
a workbook window is points. The top, left properties of
a userform is pixels. How do I convert points to pixels?

 

[Tom Ogilvy]

You might have a look here - not sure if it is exactly what you want or
would accomplish what you want:

http://www.cpearson.com/excel/FormPosition.htm
Chip Pearson's site

Regards,
Tom Ogilvy

 

[Don Ast]

It was close. I misstated my problem. But, I do love that function. It
was command bars, not userforms.

Thanks,
Don


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!