send data from userform combobox to userform combobox

**cfinch100** · 05-18-2013, 11:33 AM

hi
have looked through quite a few threads and have not seen help with this,can you enter data in one useform combobox and textbox and send or copy to a different userform and textbox,was going to use as a log in screen
cheers colin

**mikerickson** · 05-18-2013, 12:17 PM

Code like this should work

Please Login or Register  to view this content.

**cfinch100** · 05-18-2013, 12:34 PM

hi
tied thay does not seem to work ,thought id try send to sheet first then populate userform from there
cheers colin

**Charles** · 05-18-2013, 02:39 PM

HI,

I think you need both userform to be active.
If you need more than 1 userform open I think you need to set the property of the userform's
"Showmodal" to false.

**cfinch100** · 05-18-2013, 03:58 PM

hi charles
thanks for that think i have sorted now,one thing in the last code you sent cmdadd some have .value and some have ,text you had done combo1 and combo2 but these were slightly different could you let me know which to use
cheers colin

**cfinch100** · 05-18-2013, 04:13 PM

hi all
used this to send from userform to sheet5

Please Login or Register  to view this content.

use command button on userform1
then added 2 textboxes to frmissued and put

Please Login or Register  to view this content.

in the userform_initialise
this works well
hope it helps some one else have added program
cheers colin

**Charles** · 05-18-2013, 04:47 PM

Hi,

For the "cmdAdd" if you are sending data to a cell it should be ".Value".
Now for the combobox code in the "cmdAdd". Use the "Me." for the ref to the userform. My error for not verifying. So use combobox1 format.