Selected data from combo boxes to text boxes

[soulun]

Hi all

First of all I would say I'm new to excel vba and know very little about it. Most of the macros I've ever used were copied and adapted by me.

I've got a following problem.

I have a table with some data, where "A","B" and "C" columns are more and more detailed description of a place. For example, "A1" = Europe, "B1" = England, "C1" = London.
"D" column is a value (expenses in this particular place for a period of time). There are a significant amount of rows with different places (up to 200 yet)

I've got 3 combo boxes with an available list of choices in the second and third depending on the choices in the previous ones. For example, if choose "Europe" in the first one, I can choose "France" or "England" etc. and then if I choose "England" I can go for "London", "Manchester" etc. Moreover, this data may repeat a few times. For example, there might be 5 "Europe" "England" "London" across the rows. The only difference will be in the value in "D" Column. I can continue these cascading combo boxes so I'm able to see all the values for a particular place across the rows. I've found a following code for that and adapted it a bit

Please Login or Register  to view this content.

However, I wonder if it's possible to use a Text Box instead of the fourth Combo Box, so I could see all the values and not choose them. More over, I wonder If it's possible to show the values in the Text Box for the places, if 3rd and even 2nd combo boxes are not chosen (To see all the values for the "Europe" or "England", without choosing a particular city).

Thank you so much much for your help in advance
Hope it's not too onerous.

[nathansav]

something like,

for each itm in d.items
s=s & itm & " "
next itm

textbox1.text =s

havent tested

[Solus Rankin]

soulun,

Please use code tags when posting code. It maintains VBA formatting and makes posts easier to read.

To add code tags:
Click the 'Edit Post' link at the bottom of your post, highlight the code and press the # button in the toolbar.

[soulun]

sorry ^_^ tried to find it but unsuccessfully. Fixed it now

[Solus Rankin]

I would use a listbox. Everytime a value is chosen in a combobox you can use

Please Login or Register  to view this content.

Where comboboxY is the combobox the selection is taking place.

If you attach your workbook as an example, I can be more specific.

To attach a workbook, press the 'Go Advanced' button below and use the paperclip in the toolbar to navigate to your workbook.

[soulun]

Here it is.

[soulun]

nathansav,

this works for the 3 combo box (instead of the fourth combo box I have the Text Box). Will try to adapt it for the others. Thank you so much.

Decided to use the listbox, as it splits the values into the rows itself

[soulun]

Ive solved this.

Here is the code if somebody wants.

Please Login or Register  to view this content.

Now trying to find out how to allow choosing the second combobox if the first one is not chosen.