i need to automatically add combo boxes down a spreadsheet based on the number the user inputs into cell "c3." For example if i input 10 into cell "c3" it will automatically add combo boxes from cell "g9" to "g19". Please note that these combo boxes also need to be independent of one another, ie control the corresponding cell in the same row as the combo box its in.
Combo Box Number
-
-
-
Re: Combo Box Number
Why not use data Validation?
-
Re: Combo Box Number
please explain? i have never used this?
-
Combo Box Issues
I have now included the excel file for clarification.
I need to automatically add combo boxes down a spreadsheet based on the number the user inputs into cell "c3." For example if i input 10 into cell "c3" it will automatically add combo boxes from cell "e4" to "e14". Please note that these combo boxes also need to be independent of one another, ie control the corresponding cell in the same row as the combo box its in. -
Re: Combo Box Issues
Please stick to the original thread.
-
Re: Combo Box Number
Merged the two threads, thanks Norie.
If you haven't ued data validation > list, I would suggest that you search the Forum for examples. Let us know exactly what your Comboboxes are needed for.
-
Re: Combo Box Number
the boxes are needed for selecting a set of variable like post, beam, box which are inputed on a different sheet.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!