hi Cindy,

You need to put a break point at the SUB line in the userform and then
step through the code. You probably have to put a break point at the
start of each of the SUB's in the userform to find the problem.

To expand on Joel's suggestion, a break point can be inserted by
clicking a line of code near the start of each sub & pressing [F9] (note
that they can't be on declarations). From memory, break points only
exist for the life of the file being open, so in your case, it is likely
to be better if you type the word Stop on a line by itself near the
start of each sub. The "stop" phrase has the same action (as a break
point) but it will still be there when you re-open the file & will cause
the code to be interrupted when it is reached. The stop phrase will
highlight & you can then use [F8] to manually continue the code line by
line or [F5] to automatically continue. You can then narrow down which
macros work & where the error occurs by noting down each macro as it
runs. To see the hierarchy of called macros at any time when the code is
interrupted you can press [ctrl + L] to bring up the Call Stack.
Note: when you fix the problem you should comment out (or delete) all
the "stop" lines within your add-in.

I'm sorry no other solutions spring to mind, but I've realised that I
may be able to help if you were to become a CodeCage member (it's free &
you can list me "broro183" as your referrer :) via 'The Code Cage - Help
Forums For Microsoft Office Tips & Tricks'
(http://www.thecodecage.com/register.html)). Then you can upload a
zipped copy of the file in Excel 2007's compatibility mode of xls format
for Excel '97 to 2003 into this thread (http://tinyurl.com/nhtmq5).

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109219