Help with Dynamic UserForm in Excel

[Shlomi.unique]

Hi !

I'm struggling this issue for a couple of days already…..

Appreciate your help !

The file with explanation is on attached.

The case is that on UserForm I have a 1st ComboBox (for Group Field) that is the Only one that is built in advance.

All other Subgroups ComboBoxes are Dynamic ComboBoxes and build programmatically according to sheet columns.
As ComboBoxes are Dynamic, each one effect the next one.

4 things I haven't found a way to solve anywhere:

1. How can I adjust the dynamic UserForm code to work same as UserForm work on Sheet1. The logical idea is mark in Yellow on attached File.
--------------------------------------------------------------
2. How do I pass the values of All ComboBoxes to Sheet: AccIndex (i.e.: Sheets("AccIndex") on LastRow) ?
I tried those two codes but it did not work:

Please Login or Register  to view this content.

---------------------------------------------------------------
3. How do I read , progromaticaly, the headers from the sheet to the Labels on UserForm (the labels will be updated with other names) ?
----------------------------------------------------------------
4. And the last thing, I don't know if it is possible , but i'll ask anyway:
Is the logical of Dynamic ComboBoxes can 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.

For example:
let's say I have 4 ComboBoxes.

When I choose on: ComboBox4 >> 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.
can it be done ??

Your help will be appreciated !

posted on this forum as well:
http://www.vbaexpress.com/forum/show...rForm-in-Excel


Shlomi

[AlphaFrog]

Why are you adding the comboboxes programmatically? It would be much easier to have the comboboxes already on the userform and just populate them when the form loads. If you don't know how many subgroups you'll have, you could hide the comboboxes you don't need.

3.) There are no labels on your userforms. Something like this would assign a header to a label control.
Me.Label1.Caption = Sheets("Sheet1").Range("A1").Text

4.) The last subgroup combobox is not populated until it's parent conbobox has a selection. There would be nothing to select that would affect previous comboboxes.

[Shlomi.unique]

Thanks AlphaFrog for your answer.

This UserForm is part of a bigger project. in the bigger project , this dynamic userform should be pup up after double click event on ListBox.
I'm doing it programmatically as this user form should be running on several different files, which I don't know , in advance, how many columns (= ComboBoxs) they will have.
very strange that I could not find any post, whatsoever, on "How to copy Controls value, on a dynamic UserFrom, into worksheet ?" on google.....

Re. answer no. 3.
as I need it dynamically , i can not refer to a specific cell. need some kind of loop, to loop through all the headers and fetch the cells values into the Label one by one.

4) You are absolutely right, but, the logical that i've being thinks of is:
In case you choose the last combobox , the code should "see" that no combo box has being filled yet, and then the Last combobox will load into it all the items from the last column. after I choose an item it can filled the previuse (above) combo boxes.
hope it is logical what i want to do. or it is just logical to me (?)

Shlomi

[Leith Ross]

Hello Shlomi.unique,

If I am not mistaken, you posted this same question Here.

According to forum rules, we ask you let us know if you have posted a question elsewhere. Next time, please add a link to where you have posted a question.