VBA - Dropdown Controls Number of Fields?

M

misdeed

New Member
Joined
Jun 24, 2011
Messages
1
I'm working on an input form for some data that will be processed by some other functions.

I have a sections where I want a dropdown list with values 1-5. Depending on what value this is, the number of fields will match.

Ex:

In B1, it will have "Select Number of Shells"
In C1, it will have a dropdown, 1-5
Starting in B2, a list of Shell 1, Shell 2, etc. will be generated, matching the number selected in the dropdown in C1.

Can I get some help with this?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

H
  • Question Question
Using VBA to select multiple criteria in 2 dropdown lists on the same sheet
Replies
1
Views
428
My Aswer Is This
My Aswer Is This
J
  • Question Question
Dropdown dependent dropdown based upon multiple selections.
Replies
0
Views
532
jcschafer209
J
E
  • Solved
Performance issue using a combination of dropdowns & lookups
Replies
9
Views
647
Akuini
Akuini
M
  • Solved
Using a String as a Sub name
Replies
1
Views
72
Joe4
Joe4
T
  • Solved
VBA clear selection of dropdown list upon closing file
Replies
5
Views
380
tidepooler
T

Forum statistics

Threads
1,224,518
Messages
6,179,259
Members
452,901
Latest member
LisaGo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top