PDA

View Full Version : Solved: Userform entry



av8tordude
11-08-2012, 12:10 AM
Can someone assist me with this task...thx for your assistance
1. I want to be able to limit the number of textboxs that can be filled to 4. For example, the user shouldnot be able to fill-in more than 4 types of approaches.
2. For each textbox filled, enter the initials of the approch type followed by acomma into the cell in column T. Ifonly 1-textbox is filled, do not put a comma after the initials.
For example...If ILS, LOC, VOR, NDB textboxes has an entry, enter I,L,V,N (the initials for each approach type, into the cell incolumn T.

xld
11-08-2012, 02:12 AM
Try this

av8tordude
11-08-2012, 04:43 AM
Excellent work XLD!

Can I request a slight modification to the code...

I was working with the code and realized instead of limiting the number of entries, can you allow it to only enter 4 inititials and *. (i.e. I,L,V,N*) The star will represent more the 4 types are entered.

Thank you for your help.:friends:

xld
11-08-2012, 01:23 PM
Here you are

av8tordude
11-08-2012, 02:52 PM
Thank you XLD