Save Userform Textbox Value to Another Workbook

**Mooseman60** · 10-31-2010, 12:26 AM

Hi

I have a userform in one workbook that has a text box to enter a value into a worksheet on another workbook. I also have a command button so that when clicked it will save the entry to the worksheet in the other workbook and then return to the previous userform

Can anyone help me with the code for this

Thanks

**mikerickson** · 10-31-2010, 12:43 AM

You could put

Please Login or Register  to view this content.

in the Command Button's Click event.

**Mooseman60** · 10-31-2010, 02:37 AM

Mike

I take onboard regarding cross posting and will abide by the forum rules

I have placed your code but i am getting an error message on this piece of code saying

Oject variable or with block variable not set

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**mikerickson** · 10-31-2010, 08:56 AM

The variable ws has to be set before that line.

**Mooseman60** · 10-31-2010, 09:07 AM

Mike

I'm no wizard with this VBA I'm just a beginner trying to get my head around code so what is the variable that needs to go before that line

**mikerickson** · 10-31-2010, 09:22 AM

I guess that this is the sheet you want ws to refer to

Please Login or Register  to view this content.

**Mooseman60** · 10-31-2010, 09:37 AM

Mike

Have entered that code but still get the error Subscript out of range

Please Login or Register  to view this content.

**mikerickson** · 10-31-2010, 10:22 AM

Are the names spelt correctly? Is the error on the

...= txtSupplier.Text line or the
Set ws = ... line

**Mooseman60** · 11-01-2010, 05:00 AM

Thanks for your help Mike

The problem was in the Set ws = line I had txtSuppliers instead of txtSupplier

**romperstomper** · 11-01-2010, 05:35 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save