Consulting

Results 1 to 5 of 5

Thread: Solved: Userform entry

  1. #1

    Solved: Userform entry

    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”.

    Attached Files Attached Files

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try this
    Attached Files Attached Files
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    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.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Here you are
    Attached Files Attached Files
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    Thank you XLD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •