dropdown box options

Hi, i am currently designing a userform which has a drop-down box for user to choose from the options given. However, i would like to have in the box fields such as "--Subjects", "English", "Maths", "Science". In this way, the user will be shown a list of options of the different subjects for them to choose from as well as to clearly identify to them that these are the subjects available therefore the heading "--Subjects". I would also have to make sure that the user can only select "English", "Maths", "Science" and NOT "--Subjects". How should i go about doing this?

Hello Froggy19,

There are 2 ways to add information to a DropDown or ComboBox. One way is to "hard code" the entries, and the other is to use the ControlSource property to load the entries.

Hard coding prevents the user from changing the entries. It also means you have to make change to your code if you want to expand the list.

Using the ControlSource property makes changing the entries easier since they are taken from a worksheet range of cells. This allows you to exapnd the list more easily, but also means the user can potentially corrupt the entries as well.

This example hard codes the entries into a combobox named ComboBox1 on UserForm1. The "--Subjects" is displayed after the ComboBox is loaded, but not again after the user has made a selection.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello A V Veerkar,

Column headers are only available to a Control Toolbox ComboBox or Listbox when they are loaded from a Worksheet using the ListFillRange property. The first row of the range will be used for the headers provided you have set ColumnHeads property to true.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello A V Veerkar,

Column headers are only available to a Control Toolbox ComboBox or Listbox when they are loaded from a Worksheet using the ListFillRange property. The first row of the range will be used for the headers provided you have set ColumnHeads property to true.

Sincerely,
Leith Ross

Thanks a lot Leith

A V Veerkar

Hi Leith Ross,

in my dropdown box, i am suppose to put the following in the order below:

--Subjects
English
Maths
Science
--Teacher
Kenneth
Randin
Elizabeth

As such, for the particular dropdown box, they can only select either English, Maths, Science, Kenneth, Randin or Elizabeth but not "--Subjects" and "--Teacher". May i know how i can go about doing it and yet achieve this order should i want all of these in 1 field?

Thank you.

Hello Froggy19,

Will you be using data from a worksheet to load the ComboBoxes? If so, what ranges will you be using for ComboBox1, and ComboBox2?

Thanks,
Leith Ross

Hi Leith,

currently in the combobox, i am using an array to store what i want the user to select from

ComboBL.List() = Array("English", "Maths", "Science", "Radin", "Kenneth", "Elizabeth")

But is just that my supervisor would want me to add "--Subjects" and "--Teacher" into the list as i guide for users and ensuring that they are not allowed to select them

Hi Leith,

but this way i will have 2 comboboxes. What i need is to put all of them into 1 combobox only.

Thanks