In a (VBA) UserForm, how do I populate the data in a ComboBox/ListBox with a range, and have the range be populated (from existing tables) based on the selection in a previous ComboBox?
For example, if I have a sheet with columns A thru E (ranges). Each column will have a list of items, 1 through 25. When I select in the UserForm ComboBox1 Column "A". I want in the next ColumnBox2, or Listbox, to show only the items available in Column A. If I select "B" in ComboBox1, I want to see only the items available from Column B in ColumnBox2.