Pass Value/text from User Form to Macro

**tompa** · 05-24-2011, 12:36 PM

Hello All!
I have tried this solution before and it worked, but I cannot repeat the same task. I have a Database where I am supposed to look up information, and if not found add as a new row with new information. I use User forms and Macros, but the values seem not to correspond. I am new at this, so please explain clearly. The below code gives the right value in User Form, but gives the value BuggNr=0 for the Macro code. The reason why both macro and user form is why I am planning on doing several more tasks
PLS ADV
Thanks in before
/Thomas

Please Login or Register  to view this content.

**davegugg** · 05-24-2011, 12:50 PM

This has to do with the scope of the variable. I'd suggest Googling "Variable Scope" to find a good article that will help you understand all about variable scope. In a nutshell, the buggNR variable is exclusive to your CB_Hitta_Click() macro. Once that macro ends, the variable is nothing. The best way to get around this in your case should be to pass the variable as an argument in the HittaBug method.

Something like this:

Please Login or Register  to view this content.

This also brings up the importance of declaring all variables with a dim statement.

**tompa** · 05-24-2011, 07:00 PM

Excellent Dave! Thanks a lot. Will look up that article about variable scope

Pass Value/text from User Form to Macro

LinkBack

Thread Tools

Rate This Thread

Display

Pass Value/text from User Form to Macro

Re: Pass Value/text from User Form to Macro

Re: Pass Value/text from User Form to Macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions