Get Data from UserForm (TextBox, ListBox) doesnt work

**BorisMKD** · 02-04-2010, 05:54 AM

Hi dear friends,

I spent so long time to fix this problem, but it seems that I can't go on.

I have a simple question. How can I get the data from the UserForm and use it in the worksheet?

Everything works fine, only the UserForm makes problems

Here is the code:

Please Login or Register  to view this content.

Thanks in advance, Boris

**Richard Buttrey** · 02-04-2010, 06:06 AM

Hi Boris,

1. You are using Text Boxes to hold the languages, but the line

Please Login or Register  to view this content.

is looking for a non existent Text Box.

2. You are using a Select Case fLanguage (and sLanguage), without first allocating a value to these two string variables.

HTH

**BorisMKD** · 02-04-2010, 06:11 AM

I fixed only the 1. I deleted:

Please Login or Register  to view this content.

and did

Please Login or Register  to view this content.

How should I make the fLanguage & the sLanguage work?

Thanks

**BorisMKD** · 02-04-2010, 06:23 AM

Did it by myself.

Thank you Mr. Richard Buttrey for Your help.

The Code that Works:

Please Login or Register  to view this content.

**hitmen** · 01-15-2014, 04:53 AM

can you send me done file, please.
i have problem the same to you.

Thank you so much

**Richard Buttrey** · 01-15-2014, 05:07 AM

Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.