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

Dinictus · Apr 17th, 2002, 06:10 AM

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!

Audiojoe · Apr 17th, 2002, 06:13 AM

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

Dinictus · Apr 17th, 2002, 06:18 AM

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.

Audiojoe · Apr 17th, 2002, 06:34 AM

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

Dinictus · Apr 17th, 2002, 07:13 AM

Done...

Apr 17th, 2002, 06:18 AM	#3
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	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

Apr 17th, 2002, 07:13 AM	#5
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	Done... __________________ NOx installed

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 06:10 AM	#1
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	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!

Apr 17th, 2002, 06:13 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	You could change the textboxes to comboboxes and list the codes in there?

Apr 17th, 2002, 06:34 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Send me your email address and I'll send you a little example I just made for you