full screen form

I have two questions;

Is there a way to have a form full screen?

I also need a to say on an If statement if a textbox contains then.... I know you can specify = "" which means contains nothing, what is the opposite?

Thanks
Sam

These three tests are equivalent.

Please Login or Register  to view this content.

and testing their negation:

Please Login or Register  to view this content.

Hello samtwilliams,

This is more complex an operation that it seems. It requires retrieving system information and screen setting information using the Windows API. This routine returns the 4 key parameters a UserForm needs to fill the screen correctly.
Macro Code

Please Login or Register  to view this content.

Code for UserForm

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello


If the Excel application is always displayed on full screen, you could also try:

Please Login or Register  to view this content.

Regards,
michel