Create unique list using Dictionary Object in Combobx 2 based off selection of Combobox 1

In my effort to figure out how to populate a combobox with only the unique values from a worksheet list, I have discovered the Dictionary Object structure.
The following link has been helpful to show how this can be used to fill a combobox:
http://www.ozgrid.com/forum/showthread.php?t=39750

However this is for the initialize userform event. What I need is to have this dictionary object be applied to a second combobox ("CbxCity") that is filled based on the selection of a first comobox ("CbxAssetType2"). My code thus far does not seem to be correct but I am not sure why:

Please Login or Register  to view this content.

I tried using

Please Login or Register  to view this content.

for the first If statement however that does not do anything either.. Any help is greatly appreciated!

It gives an "Object with variable or With Block variable not set" error when I select an entry in the first combobox. The

Please Login or Register  to view this content.

is highlighted and x gives a null when clicked.

x isn't a range:

Please Login or Register  to view this content.

Awesome, thanks I knew it was something simple I was over looking!

Actually, I overlooked how I would use the second combobox ("CbxCity") after I got it filled with unique values. Originally it was being filled by numbers from an ID column in my table, which would reference the row number in the table. However, how can I set up this second combobox to have a second column that also grabs the corresponding value/number in the "ID#" column of my table?

For example, to fill the two column combobox I would do so through the following code (note the column position of the offset- grabs the "ID#" column in relation to the "Asset" column used in the code above):

Please Login or Register  to view this content.

However in this case, since Me.CbxCity.List is set to equal dic.keys, I am not sure how to reference the second column of the combobox and set it to equal (0,-2) position corresponding to i.value?

It appears that since dic.Keys is in fact generated as an object and not a direct reference to the sheet rows/columns, there is no way to grab corresponding column values using this method...