I have a userform, frmrelease, that has two comboboxes, cmbcontrolcode & cmbjobnum.
cmbjobnum is bound to sheet "release", column A. cmbcontrolcode is bound to column B.
Here's a mock table....
~~~~~~~~~~~~~~~~~~~~~~~
Column A Column B
123 AAA
456 BBB
123 CCC
456 DDD
123 EEE
456 FFF
~~~~~~~~~~~~~~~~~~~~~~
Now, what I need to accomplish is this. If cmbjobnum is "123", then only "AAA", "CCC" & "EEE" populate cmbcontrolcode. Likewise, if cmbjobnum is "456", then only "BBB", "DDD" & "FFF" populate cmbcontrolcode.
So far, this is what I have (thanks to Babytiger), but it's not working...
Selection.AutoFilter Field:=0, Criteria1:=Sheets("release").cmbjobnum.value
Any Ideas??
Thanks
cmbjobnum is bound to sheet "release", column A. cmbcontrolcode is bound to column B.
Here's a mock table....
~~~~~~~~~~~~~~~~~~~~~~~
Column A Column B
123 AAA
456 BBB
123 CCC
456 DDD
123 EEE
456 FFF
~~~~~~~~~~~~~~~~~~~~~~
Now, what I need to accomplish is this. If cmbjobnum is "123", then only "AAA", "CCC" & "EEE" populate cmbcontrolcode. Likewise, if cmbjobnum is "456", then only "BBB", "DDD" & "FFF" populate cmbcontrolcode.
So far, this is what I have (thanks to Babytiger), but it's not working...
Selection.AutoFilter Field:=0, Criteria1:=Sheets("release").cmbjobnum.value
Any Ideas??
Thanks