Adding to a value that will be auto filled into a textbox from a selection.

[rharri1972]

Hello everyone! I have a userform with a combo box that is populated with customers upon clicking on the dropdown arrow. Upon double clicking on the customer needed... there will be information sent to different textboxes, i.e., Click the customer i need and that customer name stays in combo box... the Customer ID number goes to textbox 1, customer address to textbox2, city, state, and zip each go to texbox 3,4,and 5. I also have Label1 at the top of the userform "Customer Order Form".

On Textbox1_(CHANGE) if the Label1=Customer Order Form then I would like for "O_" to be added in front of or before the Customer ID number.

I got as far as to type: me.textbox1.value="O"&"_"& and then i realized i had no idea of how to tell it what to do.

I would appreciate anyhelp that is given!

 

[Akuini]

Could you upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.

 

[rharri1972]

Could you upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.

Akuini... I actually figured this one out. Thank you for being willing to help. I don't know how to stop this thread or how to keep it from circulating anymore. Would you know how since i don't need help with it anymore?

 

[Akuini]

Glad you figured it out.

I don't know how to stop this thread or how to keep it from circulating anymore. Would you know how since i don't need help with it anymore?

You can't and you don't need to.

 

[rharri1972]

Glad you figured it out.

You can't and you don't need to.

ok...thank you for your help.