vba code for dependable combo box form

**zak.horrocks** · 09-19-2014, 03:32 AM

Hi there,

I am creating a form with several dependable combo boxes and I would like a helping hand to get started. I am trying to get combobox2(labelled curriculumtopicmain) to show different values dependent on combobox1 (labelled QualificationDD) selection. Heres my code so far:

If QualificationDD = "Short Course Certificate in Hospitality Guest Relations Level 1 Qualification code_ETUET_C_1" Then Show.me.Short_Course_Certificate_in_Hospitality_Guest_Relations_Level_1_Qualification_code_ETUET_C_1

Any help would be muchly appreciated.

Thanks

Zak

**romperstomper** · 09-19-2014, 03:47 AM

I'm afraid that code makes no sense. Can you give us an example of what should be in the dependent combobox based on the different values in the first combobox?

**zak.horrocks** · 09-19-2014, 03:50 AM

In combobox2 I would like :

ETUET_C_K_1_001
ETUET_C_K_1_002
ETUET_C_K_1_003
ETUET_C_K_1_004

**romperstomper** · 09-19-2014, 03:54 AM

Then the code would look something like:

Please Login or Register  to view this content.

**zak.horrocks** · 09-19-2014, 05:34 AM

Thank you, however this still leaves combo box 2 when combo box 1 is selected. Any more ideas?

Zak

**romperstomper** · 09-19-2014, 05:38 AM

No idea what you mean by that. Can you elaborate?

**zak.horrocks** · 09-19-2014, 05:40 AM

Yes sorry, when I click on Short Course Certificate in Hospitality Guest Relations Level 1 Qualification code_ETUET_C_1 in combo box 1, combo box 2 is not showing the array i.e. ETUET_C_K_1_001", "ETUET_C_K_1_002", "ETUET_C_K_1_003", "ETUET_C_K_1_004. Its still blank.

**romperstomper** · 09-19-2014, 05:50 AM

Can you post your workbook - it will speed this up greatly.

vba code for dependable combo box form

LinkBack

Thread Tools

Rate This Thread

Display

vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Re: vba code for dependable combo box form

Thread Information

Users Browsing this Thread

Similar Threads

Code works with Combo Box-Form Control, but not with Combo box - ActiveX Control

Dynamic Dependable activex combo box with vba

combo box user form code for two combo boxes

vba - dependable combo box - runtime error '1004'

Dependable combo box

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions