UserForm Control Display

Gents,

If I call UserForm2 from button attached on UserForm1 (CommandButton1) , then I can't click again other button on the UserForm1 (let's say: CommandButton2) because of UserForm2 activated.
What is the code that I can use to enable click button on the UserForm1 while the UserForm2 is activated? (then the next steps is the UserForm2 will be hided/disappeared if any other button enable to click on the UserForm1 (CommandButton2).
Thanks in advanced for your helps.

Regards,
Iqballhud

Good morning iqballud

You make is modal.
It's easy enough : something like this should do :

Please Login or Register  to view this content.

This will allow the focus to be on another object other than the userform.

The default is always modeless (focus on userform only), but lazy Microsoft programmers seemed to set it so that anything following the "Show" command would make a userform modal. Try replacing the "modal" with "0", or "Jim" or even "modeless". Interestingly, "0" is the only numeric character accepted - anything else will generate an error.

HTH

DominicB

Good morning too DominicB,

I've been tried as your advice, unfortunately still not working.

Please Login or Register  to view this content.

Regards,
Iqballhud

Hi iqballud

I can't tell from your post what problem you're having, so apologies if I'm speaking way below your level here ...

You do know that each userform has only a label, and that labels aren't designed to be altered by the end user? They are just that. A label.
I have taken your file and amended it slightly putting a textbox on the user form, that an end user can alter, and it seems to work OK.

HTH

DominicB

Hi DominicB, thank's to be patient with me...you are great Man...appreciated to you.
Your code is working and as my expectation.
Thank you Sir.

Best Regards,
Iqballhud