CAspect

New Member
Joined
Nov 5, 2018
Messages
4
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?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
17,247
Office Version
  1. 2013
Platform
  1. Windows
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.
 
Last edited:

CAspect

New Member
Joined
Nov 5, 2018
Messages
4
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

Well-known Member
Joined
Jul 5, 2014
Messages
17,247
Office Version
  1. 2013
Platform
  1. Windows
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-known Member
Joined
Jul 5, 2014
Messages
17,247
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,996
Messages
5,575,433
Members
412,664
Latest member
akilah03
Top