Re: simple VBA issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: icestationzbra (icestationzbra.134enh_at_excelforum-nospam.com)
Date: 03/14/04 

Date: Sun, 14 Mar 2004 12:20:07 -0600

hi JEM,

try as i might, i was not able to get it to work. no matter what i
declared as the type (variant et al), it still gave me a Type Mismatch
error.

i think, i may be missing something.

i came up with a workaround. there is a text box where in the user
enters the userid. i took that and used it in the vlookup statement
that you gave me. it works like a dream. it does exactly what i
intended it to do.

thank you very much for providing me with help.

regards,

mac. 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages