A Combo Box List that is user input dependant?

AC1982

New Member
Joined
Jul 9, 2009
Messages
40
Hi,

I have created a userform that allows the user to change mark-ups on indivual Direct Job Costs.

The user does this by types in a 'job reference' and then setting his mark-ups.

This works absolutely fine.

My problem now is that I have changed the 'job reference' field from a text box to a combo box because I would like each 'job reference' typed in by the user to be stored and used to make up the combo box list. So that the combo box list only includes those 'job refernces' that have been marked up by the users.

I have also created a check box that is used as follows -

When the check box is checked all fields in the userform are disabled except for the combo box which changes into a list box only, and the list is made up of all job references marked up by users.

Does anyone know how to go about doing this?

Thanks for your help.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,550
Messages
6,179,463
Members
452,915
Latest member
hannnahheileen

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