• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Userform with two release types.

vletm

Excel Ninja
S P P
Do You need to keep both threads open?

... then You should add there something, which makes those more interesting.
 
Last edited:

Belleke

Well-Known Member
Does this help? (see example)
I understood that you wanted everything in 1 column.
Tip: avoid using unnecessary message boxes,most users are annoyed by them and have to perform an additional action,namely pressing a button.
Do not close the userform unnecessarily,maybe the users want to fill in more data.
 

Attachments

S P P

Member
Belleke
Good Morning!
Thank you for your help

The modification was good.
However, if the user enters a number in the textbox for letters it is also accepted, for this reason when placing that message it was to explain that he could enter only Letters or only Numbers by obligation
 

Belleke

Well-Known Member
Hi,
I ajusted the example, as you wil see, It is impossible to enter letters in the Numeric fields,and it is impossible to enter Numbers in the non numeric fields. Certainely no need for these annoying messageboxes.
See example
You seem to have very little faith in your employees.;)
 

Attachments

S P P

Member
Belleke

Good evening!

Thank you again.

It is perfect

You can sort the column of sheet1 of the Userform itself
 
Top