OK! How about some information?

Does anyone know the API equivalent to SCALEX function?

Please provide an example if possible!

Thanks.

Why would you need that? AFAIK All screen related stuff in API are specified in pixels

I am using Excel and trying to make one of the userform to be the size of the screen width. How might you suggest me attacking this problem?

I am using the Move method to position and size at the same time. Userform has no maximaze state.

Here is actually a better question. In Excel, the userform is similar to a VB form but does not have some functionality. It does not have hDC or hWnd. How can I obtain hDC or hWnd for the userform in Excel?

Because once having one of this, I will just use the SetWindowPos API.

Thanks

Dunno much about programming Excel apps, but
Do you have something like Screen.TwipsperpixelX?

Since you can get the screen size by

Code:

---

Screen.Width/Screen.TwipsperpixelX
Screen.Height/Screen.TwipsperpixelY

---

You can use Findwindow API to find the userform in Excel, You just need to find out the classname of it.

Quote:

---

Originally posted by kedaman
Dunno much about programming Excel apps, but
Do you have something like Screen.TwipsperpixelX?

Since you can get the screen size by

Code:

---

Screen.Width/Screen.TwipsperpixelX
Screen.Height/Screen.TwipsperpixelY

---

---

No such thing in Excel!

That is right, I forgot all about FindWindow!

Thanks Ked!