Controlsource Set

[shyampanda]

Hi,
I have a worksheet with 2 userforms (Userform1 &2). In Userform1 i have a Combobox1 which value will show in the Userform2 Textbox1 when i will unload the Userfomr1. I have checked this can happen by use of Controlsource. But i am not aware of it how can i set. Please help. Thanks.

[Norie]

You could only do it if you transferred the value from the combobox on UserForm1 to a cell and set the ControlSource of the textbox on UserForm2 to the cell you put the value in.

It would be far easier to just transfer the value straight into the textbox from the combobox.

How you would do that would really depend on how/when you are showing the 2 userforms.

[shyampanda]

Hi,
Thanks Mr. Norie for your suggestion. But can you explain how to do this if the Combobox value is transferred in a cell and it will show in the Textbox in Userform2. Waiting for your reply. Thanks.

[shyampanda]

Hi,
Thanks Mr. Norie for your suggestion. But can you explain how to do this if the Combobox value is transferred in a cell and it will show in the Textbox in Userform2. Waiting for your reply. Thanks.

[shyampanda]

Sorry posting double reply. So i have edited because it was not deleted.

[D0se]

Without seeing your workboook heres my solution:

1. Passing the combobox1.value to a global variable on userform1 unload
2. Set textbox1.value to this variable on userform2 load.

Sample workbook uploaded.

Sample_Text_Transfer.xlsm

[shyampanda]

Thanks Mr. Dose for your help. It is working fine. My problem solved.