Combo Box Drop down list shows complete list but in excel it does not

Hello,

I have a communication file I have built out and I was asked to add an additional sign off section. I have added everything and in the VBA editor I can see the new added item in the drop down list however when I go to the excel tab and click on the button that brings up the combo box the drop down list in excel is missing the new item. Any idea what I am missing? The other drop down in the same combo box where I added new items worked fine so not sure what is going on. The button is on the recovery summary info tab labeled sign off which corresponds to a sign off form in vba.

Very difficult to help as the VBA project is password protected

oh shoot. haha. epcomm

I figured it out. I had to go to excel and go into design mode and view code from there. There was code hard coding the list range. Thank you.

Glad to hear you sorted it & thanks for letting us know.