Thank you. I'll give it a try.

JLGWhiz wrote:
Joe, the code you have posted will not, in and of itself, cause T55 tp be
cleared. However, if you have some worksheet event code that triggers when
you go from one sheet to another, it could be causing it. You also have to
be very careful when you use Select and Selection in your code, because you
could issue a command for a Selection with the wrong cell or range selected.
If you know how to walk through the code line by line, you might want to do
that while watching cell T55 and see exactly where it dissapears. To execute
the code and watch the worksheet at the same time, just click the minimize
button for the VBE and you can use your mouse to grab the edges and size it
so that you can see the code and the worksheet at the same time. Then use F8
or the step button on the debug toolbar to step through the code. To shorten
the process, you can put a breakpoint on the line where you paste to T55 and
then start the line by line stepping from there. To set the breakpoint,
click on the panel between the code window and the project/properties window
of the VBE. When you find the actual line of code that does the delete, post
back if you need help fixing it.

I have a problem with a CheckBox on a UserForm that I can't figure out how to
fix or work around, and I was hoping somebody could help me with it. I have a
[quoted text clipped - 39 lines]

I hope this is enough info. Any help at all would be appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200810/1