I have a combo box (cmbType) that will have 2 values: Sample or Product
I have a second combo box (cmbStatus) that I want it to have certain values based on cmbType.
If cmbType.Value = "Sample" Then I want cmbStatus to have the following 2 values: Send via UPS or Send via FedEx
Otherwise if cmbType.Value = "Product" then I want cmbStatus to have the following 3 values: DHL, USPS or FedEx
How can I do this using VBA, I will be adding it to the "OnEnter" event of cmbStatus.
Thank you in advance!