Setting an Object to a Variable

**djbomaha** · 11-15-2012, 02:21 PM

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.

Formula:

Please Login or Register  to view this content.

**AlphaFrog** · 11-15-2012, 02:54 PM

Try this...

Please Login or Register  to view this content.

**xladept** · 11-15-2012, 02:57 PM

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** · 12-27-2012, 04:46 PM

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.