Setting an Object to a Variable

[djbomaha]

Short and sweet, I am trying to set an Object to a variable and am getting a "Type Mismatch" error on the line noted. I have tried other things and still can't get it to work, so I'm sure I'm missing something easy.

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[xladept]

You're trying to set an object to a string - you need to qualify your setting by the combo box:

Please Login or Register  to view this content.

or something like that.

[djbomaha]

Thanks guys. Both answers helped me out a lot and it allowed me to do a lot of things with userforms I didn't know were possible.

Anyway, I thought I had posted a response back in November, but apparently I didn't hit the right button or something.

[xladept]

You're welcome!