Combobox change event

Greetings:

Been trying to figure out how to get my combobox to change a cell value on worksheet before a sub runs. Right now it only changes after the commandAdd has been clicked. I need to have the cell value change on the worksheet while the form is open so the label captions on the form I have associated with the combobox selection changes dynamically. Do I need a change event and if so am I to reference the combobox list index?

Code below:

Please Login or Register  to view this content.

Thank you for the time!

pt

Solved it! Thank you to the community.

Have a good weekend.

pt