Populate a Text Box from a Change event in a Combo Box.

[jwalma]

Have a problem of my own and it is probably really simple and I am making it hard.

I have attached an example set up with a user form I am building. I currently have the first combo box loading upon the initialize of the user form an from that I choose one of the product types and it gives me a list with all product names associated in the second combo box. Upon a change event in the second combo box I want to populate the 3rd Column with the count of how many of that Product type.

Any help is a appreciated. I have a couple different code set ups in the attached sheet and neither works.

[ajryan88]

Hi,

Something like this?

I hope this helps

[jwalma]

I see no change in what I did still get the same error did you forget to attach something?

[ajryan88]

Oh I think there was a problem with the Forum yesterday, as this is the second time today I've been notified of my attachments not attaching from threads I responded to yesterday. Give me 5 minutes and I'll attach it to this post...

[jwalma]

Yes works nice I see what the difference was in the additem; a fresh set of eyes never hurts Thank you for the help.

[jwalma]

Solved Works good

[ajryan88]

No worries!

Please don't forget to click on the * next to my post to say thanks

[jwalma]

Thank you I added to your reputation