Second Combobox refresh

[walters123]

Hi I've been playing with an excel sheet that will help me put electrical quotes together using a database of items and costs.
The only thing I can't get my head around is how to activate the second combobox once the first combobox has been selected.

So for example:

If the first combobox is "Hager - Design 10" then the second box should display "Enclosure 4 Module DIN Rail White Steel".
My problem is the second combobox does not automatically update, only when I click in the box. Does anyone know how to fix this?

[AlphaFrog]

Perhaps something like this...

Please Login or Register  to view this content.

[walters123]

Cheers for the reply, don't think that does the trick.
It changes the second "combobox2" but it does not actiavte the box and when I click it the value goes blank?

If I put:

Please Login or Register  to view this content.

That is what I'm after, the only problem with this is that the dynamic named range is not updated

[AlphaFrog]

Please Login or Register  to view this content.

[walters123]

That's the one! Thanks for that

[walters123]

One other thing if you'd be so nice. When I press the button it adds the value to the spreadsheet, which is what I'm after.
The only problem is I have to click in column D first and then click the button so it is inserted correctly. Any ideas how I could achieve it? So I can click in any column along the row and it will insert correct?

[AlphaFrog]

Please Login or Register  to view this content.

[walters123]

Nearly. Only problem is when I select anything in the second list "combobox2" it just resets to the first value. I've uploaded the latest file

[AlphaFrog]

I have and older version of excel which doesn't work with the newer version of controls (comboboxes). So I can't actually use your workbook. I can see it, but I can't use the comboboxes.

[walters123]

Ah right OK. Well for some reason when I select anything from the second combobox, say item3, when I click it the combobbox looks like it resets and goes to item 1 again

[AlphaFrog]

I don't see anything that could cause that. Sorry.

As a test, comment out this line to see if somehow this procedure is unexpectedly triggered and resetting Combobox2.

Please Login or Register  to view this content.

[walters123]

I changed the code to this to see whats being called:

Please Login or Register  to view this content.

For some reason when I select from the second combobox, message box 2 pops up (which is whats expected) then message box 1 appears and then message box 2 again. This is why I think it resets the combobox. Any ideas why it does this? If that makes sense?

If you're lost I'll just remove .ListIndex = 0 from the code and leave it at that

[AlphaFrog]

I have no idea why a Combobox1_Change event would get triggered when Combobox2 is changed.

This code will check if the value of Combobox1 changed from the last time it was triggered. It's a kludge, but it should prevent resetting Combobox2 unless the selected value in Combobox1 changes.

Please Login or Register  to view this content.

[walters123]

Sorry for the late reply. That works a treat. Thanks again you've been a massive help!