Most valuable professional
  • Hot Topics

Excel 4 Dependent Combo Boxes

Hi Guys, I hope you?ll be able to assist me with the below code. I?m trying to build 4 d active dependent Combo Boxes. I got great assistance from one of the forum members here. However, I?m afraid the code works perfectly till ?Case 3000?, starting from this case, it doesn?t work properly at all. Can someone check it for me? What is missing here? Additionally, I need to know how to assign such macro to a button for example to trigger it? Code: Private Sub UserForm_Initialize() With ComboBox1 .AddItem "Placement Tests" .AddItem "Courses" .AddItem "Miscellaneous" End With End Sub

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 18, 2018.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel