Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: userform: fill the different textboxen with the use of a pic

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi all,

    I have a working userform which functions well. It has 14 input textboxen which my support people can use to build a small dataset. (for coding open market research comments, like: no dislikes=0293, I like the smell=9787)

    Now: here`s what I like: I would like a small button right next to each textbox which the people can use to choose the input code from. (right now they have the codes on paper next to them and they have to type in the code everytime)

    The list with all comments is the same for every text box, so that makes it easy.

    Can I perhaps create a subsheet with al the comments and somehow refer to this? Is there anyone who has experience with this?

    Thnks!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could change the textboxes to comboboxes and list the codes in there?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    He joe!

    yeah I could. The problem is that the discription needs to be visible. If a certain one is choosen: only the code is filled in. Like: i choose "no dislikes" and 0192 is filled in.

    And: there are about 300 codes... So dropping down would mean an enormous list.
    I actually want to make a menue kind of drop down thing like the srart menu for example.



    NOx installed

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Send me your email address and I'll send you a little example I just made for you

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Done...
    NOx installed

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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