Userform enable/disable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try using the :
Userform.Hide and
Userfrom.Show instead

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

Corey....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing the textbox value without changing the textbox format? 2
Code stops while Userform Shown 2
Question about modal userform..... 2
Prevent user moving the userform with mouse 2
CheckBox 2
Referencing a UserForm in a Module 2
Excel Userform 3
workbook used to open but now crash with File/path error 5

Back
Top