ExcelBanter - Userform enable/disable

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Userform enable/disable (https://www.excelbanter.com/excel-programming/387120-userform-enable-disable.html)

Ozgur Pars[_2_]

Userform enable/disable

Hi there,
I have a userform which I "disable" after a submission with
Userform1.enabled=false. And after some calculations in another sub I have
Userform1.enabled=true. However the form is not enabled. Why?

I would appreciate if anybody could help me around this problem.

Thanks,
Ozgur

Coza

Userform enable/disable

Try using the :
Userform.Hide and
Userfrom.Show instead

The user cannot alter the Userform if it is NOT displayed.

Corey....
"Ozgur Pars" wrote in message
...
Hi there,
I have a userform which I "disable" after a submission with
Userform1.enabled=false. And after some calculations in another sub I have
Userform1.enabled=true. However the form is not enabled. Why?

I would appreciate if anybody could help me around this problem.

Thanks,
Ozgur

All times are GMT +1. The time now is 05:28 PM.