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

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

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

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




.

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




.

Bob,

I have set the checkboxes (1 for starters) to have a
default value of true, but even then it causes issues.
The user needs to only check the box(s) that are
applicable to his/her change request, not uncheck all the
others. But even then, the box(s) does not show as
checked after the form is reactivating, so that if the
user decides to uncheck the box the value changes
accordingly.


-----Original Message-----
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




.



.