Cannot insert cells into VBA?

It's not clear to me what is your data structure in the worksheet, nor where this code is inserted, but let's try at the beginning:

Please Login or Register  to view this content.

or may be:

Please Login or Register  to view this content.

If that's not enough, will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

As Kaper said it would be useful to see your workbook. Howvere if ComboBox20 does contain items like "BRCKT010" then perhaps:

Please Login or Register  to view this content.

If I understand the question and you've a list of values in the worksheet that you want to appear in the ComboBox then the simplest way of populating one of the Controls, like a ComobBox, ListBox etc. with values is to use the .RowSource property

List the values you want to populate in a range of cells and give a name to the range say 'MyRange'

Then in the Properties window of the combobox enter the name MyRange

You'd want more than one cell:

Please Login or Register  to view this content.

for example, where Z2:Z20 contain your list values.

Regarding your initial question, I suspect you'd be better off just using a lookup table and finding the selected value and its corresponding data, instead of using a Select Case construction.