ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Can't Show Modally" - Run-Time Error '400' Problem (https://www.excelbanter.com/excel-programming/271448-re-cant-show-modally-run-time-error-400-problem.html)

Bruce B[_2_]

"Can't Show Modally" - Run-Time Error '400' Problem
 


Thanks Tom!

BTW, What exactly does modal mean?

- Bruce

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

Tom Ogilvy

"Can't Show Modally" - Run-Time Error '400' Problem
 
if a userform is modal, you can't select out of the userform (for instance
you can't select on the worksheet). The userform retains the focus.

Regards,
Tom Ogilvy

ruce B wrote in message
...


Thanks Tom!

BTW, What exactly does modal mean?

- Bruce

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




Vasant Nanavati[_2_]

"Can't Show Modally" - Run-Time Error '400' Problem
 
Hi Bruce:

A modal form is one that will not allow you to perform any other activity
within the application until it (the form) is dismissed. A modeless form can
float over your active worksheet while allowing you to work on the worksheet
at the same time.

Regards,

Vasant.

"Bruce B" wrote in message
...


Thanks Tom!

BTW, What exactly does modal mean?

- Bruce

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




Bruce B[_2_]

"Can't Show Modally" - Run-Time Error '400' Problem
 


Thanks!

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


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com