John,
If you are bound to a source the default will of course be that source.
If the check box is not bound to a cell, then the value property is the
default. Sounds like you need to have your checkboxes unbound with their
value property set to true.

Bob L.


"john petty" wrote in message
...
Bob,

that is not doing what I need it to do. What I am
trying to do is like what is now done to the textboxes,
(show up when the form is re-activated). Using the triple
source even at false is giving me 3 stages (null, true,
false) and even without the control source pointing to the
range cell, when the form is reactivated, none of the
checked boxes are shown as checked.

-----Original Message-----
The tripleState property set to true is what allows a
greyed out checkbox
to deal with a null value. The linked cell should be
showing either True or
false (or nothing if triple state is true).

Bob L.
"John Petty" wrote in message
...
Thanks Bob. No for another question. If I add a
control
source for the checkboxes, the checkboxes shade a
checkmark and I get "**" on the sheet. Is there a way
to
set a control source then set the default to false
unless
checked (for the adding data set)


-----Original Message-----
Not sure how you are transferring your data, but if you
bind the text box to
a cell on a worksheet, the value will be there when you
open the form the
next time. You can do this by naming the cell and then
entering that name
in the controlsource value for the text box
(Properties,
controlsource)

Bob L.

"john petty" wrote in message
...
Sorry about that. Try it again.

I have a userform that transfers the data to a
spreadsheet. This userform uses both textboxes and
checkboxes. When I enter the data and press the ok
button, every thing works perfectly. But if I reopen
the
dialog box to add more data, all the boxes are blank
and
when I press the OK button everything has either been
reset except for the original checkboxes (If I add no
data), or it overwrites the existing data.

1) Is there a way to have data entered earlier, show
up
in
the appropriate boxes so I don't have to retype or
reset?

If the answer to #1 is No then

2) Is there a way if I reopen the dialog box all the
data
is reset (including the checkboxes)?

TIA

John Petty




.