Don't know if you saw my other post yet - hopefully it can help with the error.

And good luck continuing to learn VBA (we never finish learning it!) - seems
like you are off to a good start if you figured out as much as you did. I am
a teacher at heart (only occasionally in my work history) but I think I key
into posts from people who say they are new to VBA. I appreciate those who
are so eager to learn.
--
- K Dales


"MarianneR" wrote:


Thank you so much for your help. I so appreciate it!!

On the second part of my post, I was referring to a User Form that I
had created. I used two command boxes - one to dump the data into the
spreadsheet and the other to close the form. If I click the mouse
outside of any of the User Form cells or command buttons, the error
occurs. I'm sure there's some way to work around this, but I haven't
figured it out.


--
MarianneR
------------------------------------------------------------------------
MarianneR's Profile: http://www.excelforum.com/member.php...fo&userid=6253
View this thread: http://www.excelforum.com/showthread...hreadid=475191