10shlomi10
12-05-2016, 07:12 AM
Good Day All !
I'm struggling this issue for a couple of days already…..:banghead:
Appreciate your help !
The file with explanation is on attached.
The 1st ComboBox (for Group Field) is the Only one that is built in advance.
All other Subgroups ComboBoxes are Dynamic ComboBoxes and build programmatically.
As ComboBoxes are Dynamic, each one effect the next one.
4 things I haven't found a way to solve:
1. How can I adjust the dynamic UserForm code to work same as UserForm work on Sheet1. The logical idea is mark in Yellow.
--------------------------------------------------------------
2. How do I pass the values of All ComboBoxes to AccIndex Sheet (i.e.: Sheets("AccIndex") on LastRow ?
---------------------------------------------------------------
3. How do I pass the headers to the Labels on UserForm (they will be updated with other names) ?
----------------------------------------------------------------
4. And the last thing, I want that the logical of Dynamic ComboBoxes will work from Last To first ComboBox , as well.
Meaning, If I'll choose the 2223-3 from Last ComboBox, all the ComboBoxes above it, should already "Know" which values should be taken in them.
Meaning: let's say I have 4 ComboBoxes.
When choose on: ComboBox 4 >> 2223-3
it should give on ComboBox3 >> 2222-2 and 2223-2
and on ComboBox2 >> 2222-1
and on ComboBox1 >> Group 2 ; The 1st ComboBox (for Group Field) is the Only one that is built in advance.
How I can do it ?:think:
Many Many Thanks !
I'm struggling this issue for a couple of days already…..:banghead:
Appreciate your help !
The file with explanation is on attached.
The 1st ComboBox (for Group Field) is the Only one that is built in advance.
All other Subgroups ComboBoxes are Dynamic ComboBoxes and build programmatically.
As ComboBoxes are Dynamic, each one effect the next one.
4 things I haven't found a way to solve:
1. How can I adjust the dynamic UserForm code to work same as UserForm work on Sheet1. The logical idea is mark in Yellow.
--------------------------------------------------------------
2. How do I pass the values of All ComboBoxes to AccIndex Sheet (i.e.: Sheets("AccIndex") on LastRow ?
---------------------------------------------------------------
3. How do I pass the headers to the Labels on UserForm (they will be updated with other names) ?
----------------------------------------------------------------
4. And the last thing, I want that the logical of Dynamic ComboBoxes will work from Last To first ComboBox , as well.
Meaning, If I'll choose the 2223-3 from Last ComboBox, all the ComboBoxes above it, should already "Know" which values should be taken in them.
Meaning: let's say I have 4 ComboBoxes.
When choose on: ComboBox 4 >> 2223-3
it should give on ComboBox3 >> 2222-2 and 2223-2
and on ComboBox2 >> 2222-1
and on ComboBox1 >> Group 2 ; The 1st ComboBox (for Group Field) is the Only one that is built in advance.
How I can do it ?:think:
Many Many Thanks !