cascading combo box

Hi All, relative newbie to VBA and MrExcel so gentle on me please... I have information in three columns (Dept, Supervisor, Employee) that I want added to separate combobox's in a VBA userform. Each employee can only work for one supervisor, and each supervisor can only work in one department...

Hi there, I am trying to create a User Form using ComboBoxes and am struggling with a couple of things: 1) I have populated my ComboBoxes successfully (these cascade down 5 levels) but, if I select an option in ComboBox1, for example, the relating options in ComboBox2 do not appear until I...

Hi, first I want to thank you in advance for helping me out. I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...

Hi, first I want to thank you in advance for helping me out. I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...

I've been using the subroutine for my database and now need to move it to a web database. I use the combo box for one selection, to fill in my other fields Ive been using the Me.TXTHULL_NO.Value = Me.CBO_CONT.Column(1) line to input for my other fields. How can I use something similar for...

Help - I'm getting a bit goofy with this. My form: has 4 cascading combo boxes - they work perfectly. 1st combo box updates my main table just fine - my #2 box (which is dependent upon 1st combo box choice) does not feed to my main table. After reading several threads, I think I want...