Reverse combobox and textbox dependency in Userform

Hello,

I am trying to make the Project Name box details be dependent on the Project Number selected in a combobox drop down selection. Essentially, I am trying to reverse the dependency which is already in place (right now the Project Name controls what is displayed in the Project Number text box). I've tried renaming the Project Name Combobox to the original name of the ProjectNumber box, and reversing the code in the back which controls the change of the Project Name.

Unfortunately my attempts have not worked. Can someone assist?

My form is attached:

This is the code which is causing me issues:

Please Login or Register  to view this content.

Originally Posted by sintek

Hi there

Please help me understand....Are you wanting to select the project number and have the project name appear

Hi Sinitek, that's exactly it! Right now, it works so that you select the Project Name and then the Project Number appears. I would like it in reverse...

HiSintek, I thought it would be that simple too..but the form keeps erroring out when I just do....

Thank you both, Sintek and Bakerman. Both codes do the job!