Hello,
I've created two ActiveX ComboBoxes.
The first ComboBox (cb_DSelection) has the entries "Laptop" and "Workstation".
The second ComboBox (cb_DType) should list the devices dependent on the selection of the cb_DSelection ComboBox.
For this I have created a second worksheet called "Data" where the devices are listed, the ComboBoxes are on the first worksheet.
I've given the cells containing the Laptops and Workstations the same name as listed in cb_DSelection and tried to link cb_DType with cb_DSelection with the following VBA Code:
The selection of cb_DSelection should change the Values in cb_DType.
But this code does not work.
Any ideas or hints how to get this done?
Bookmarks