Hey Tom,

It's a bit more complicated then that i'm afraid.

The paste down is done within a With statement. using the cbx1.value
I can get "TRUE" in the correct column. All of my code on the sheet
is looking for a "Y" not a "TRUE". I was looking for a way to convert
the "TRUE" to a "Y" before it pasted down with the rest of the row.

Oh, in case I forgot to mention it, thanks for the assist on finding
the sheet with the mmm-yy formatted name tabs. I finally got that
section working (this is in the same UserForm).

I am looking for a simple solution, if there is no "simple" solution,
then I can go into the sheet formulas and change them to look for
"TRUE" instead of "Y"

TIA

-Minitman


On Tue, 26 Oct 2004 19:34:55 -0400, "Tom Ogilvy"
wrote:

Private Sub cbx1_click()
if cbx1.Value then
worksheets("Sheet1").Range("A1").Value = "Y"
else
worksheets("Sheet1").Range("A1").ClearContents
end if
end Sub