VBA code doesn't remember data

**minifreak** · 08-19-2013, 04:10 AM

I have a simple userform where a variable named X is set, depending on a combobox, as seen below..

Please Login or Register  to view this content.

it's not the whole code but just to see what is needed. When a user selects 'Order' from the combobox, variable X should be a specific website.
It works because a messagebox is shown with the correct website.

Now I also have a Button in the userform and when this button is pressed, it should open the website (X) in a new window, but this doesn't work...
the code for the button is:

Please Login or Register  to view this content.

However, the variable X is no longer filled with the website address !

I think it's because I used the End Sub and start a new Sub but I'm not sure how to do the trick so the website opens when the button is pressed

**watersev** · 08-19-2013, 04:28 AM

hi minifreak, option:

Please Login or Register  to view this content.

**AlphaFrog** · 08-19-2013, 04:31 AM

Put this at the very top of the code module above all the procedures.

Dim X as String

This will declare the variable X and it will be accessible to the other procedures within the code module.

**minifreak** · 08-19-2013, 04:56 AM

@watersev, Your option worked, I tried it before but I wanted to set the variable earlier when and I knew it had to be something with Dim As...
@ AlphaFrog, I put the Dim As function like you mentioned at the top of the code and now it worked !!!
Earlier I had the same line of code but inside the Private Sub ...... End Sub and this didn't work.
Now I'm just glad that I can continue with the code