Best way to set-up this form

[CAspect]

I am trying to create a form in excel.

With certain questions the user can select multiple options.


For instance:

What type of fruit would you like? (I used an active x combo box for this)

No Fruit
Apples
Oranges
Pears
Grapes

I want the user to be able to pick multiple options at once and IF they pick any of the options besides "No Fruit" I want a text field (or whatever you think) to appear and say How many?


I need suggestions on how to set this up and then how to create the code for the text box to appear under those conditions.

Can anyone help me out?

 

[My Aswer Is This]

We could put a script in the combobox that says if you pick any thing other then.

And then a Inputbox could popup and say how many.

But then what would the script do next?

And if several items were selected would you need several input boxes to popup?

Please explain in detail what your ultimate goal here is

And please define Form.

Do you mean UserForm.

 

[CAspect]

Yes, I would need an input box for each selection. In some instances they could pick one, but some they need to pick two and each would need a box to enter a qty. I am new to creating forms, but essentially what I am trying to do is create a form for sales. We have numerous products and within each product we have many options. In the past our forms have looked very busy and I am trying to avoid that by creating this with options only showing up if a certain features are selected. Then this form will be sent to a team to price out.

So after that script was ran to obtain the qty it would stop there since that is all the info we would need for that question.

If you can help me on how to set that up I could (hopefully) recreate for other combo boxes.

Thanks so much

We could put a script in the combobox that says if you pick any thing other then.

And then a Inputbox could popup and say how many.

But then what would the script do next?

And if several items were selected would you need several input boxes to popup?

Please explain in detail what your ultimate goal here is

And please define Form.

Do you mean UserForm.

 

[My Aswer Is This]

It's hard to help when you do not answer questions:

I said in last post:

And please define Form.

Do you mean UserForm.

And I see no way how just asking how many can be last thing the script does.

So you choose Apple from listbox
Then Inputbox says how many
You enter 20 and the script ends.

And all this data is now lost if we do not enter this data some place.



​

 

[My Aswer Is This]

Well by looking back at one of your previously posted questions. When you say Form you mean sheet.
But still not sure where you want the results entered.