Quote Originally Posted by simcode View Post
I'm not clearly about what r u going to do, what result do you want. I've write several examples in the workbook.
Try it.
Its almost there

Why do you put 3 showforms? "Showform" , "showform1" , "showform2"



In the msgbox displaying checkbox's caption, can you put all line to left? (the checkbox's caption are starting with a TAB and then caption) - if any question let me know so i can explain better.

For my issue with "ADMIN" and "ELSE"
I noticed that Showform and showform1 open and the showform2 open and close.

I need to have something similiar according to a cell, but if possible same showform.
I will try to explain better.

This form needs will have textbox's values according to cell values ( i will put this in userform initialize).

Although if the cell a1 in sheet "ORDEM TRABALHO ENVELOPES" is different than "ADMIN" the userform must open, then click automaticly in button "Confirmar" (green one) and without even appear the userform, i mean, it's running in background, probably using displayevents = false will do the job, let me know.


If it is ADMIN in that cell, than open the userform only, then the user will edit the textbox's mannually and click manually in "confirmar" button.
If else, open in background and Confirm, printing the default ranges i put in userform_initialize and showing message.

Thanks again for your fantastic help, it's just this small things and i'm done :D