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




.



.

John,
I'm not following you. You can also set checkbox values using the
activate event of the user form. For example, if the checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
...
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




.



.

Getting the Checkbox values is done. The problem is that
when I reactivate the userform, I can now get the
Textboxes to show the data that was previously entered,
but the checkboxes that were previously checked are not
showing as checked (but the cells themselves have values

i.e
If CheckMachineNotice = True Then Range _
("MachNotice").value = "X"

When the form is reactivated, the data in Range MachNotice
is there but the checkbox does not reflect that anything
has been done (i.e. false)


-----Original Message-----
John,
I'm not following you. You can also set checkbox
values using the
activate event of the user form. For example, if the
checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
...
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




.



.



.

John
Are you binding the checkbox using controlsource or you using an if
statement to set the value of the cell?

Bob L.


"john petty" wrote in message
...
Getting the Checkbox values is done. The problem is that
when I reactivate the userform, I can now get the
Textboxes to show the data that was previously entered,
but the checkboxes that were previously checked are not
showing as checked (but the cells themselves have values

i.e
If CheckMachineNotice = True Then Range _
("MachNotice").value = "X"

When the form is reactivated, the data in Range MachNotice
is there but the checkbox does not reflect that anything
has been done (i.e. false)


-----Original Message-----
John,
I'm not following you. You can also set checkbox
values using the
activate event of the user form. For example, if the
checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
...
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




.



.



.

Bob, I am using If/Then statements to set the values.
would it be cleaner to set a ControlSource?


-----Original Message-----
Getting the Checkbox values is done. The problem is that
when I reactivate the userform, I can now get the
Textboxes to show the data that was previously entered,
but the checkboxes that were previously checked are not
showing as checked (but the cells themselves have values

i.e
If CheckMachineNotice = True Then Range _
("MachNotice").value = "X"

When the form is reactivated, the data in Range
MachNotice
is there but the checkbox does not reflect that anything
has been done (i.e. false)


-----Original Message-----
John,
I'm not following you. You can also set checkbox
values using the
activate event of the user form. For example, if the
checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
.. .
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




.



.



.

.

If you use controlsource it is going to put true or false in the cell rather
than an X like you are doing. Doing it your way there is no direct linkage
between the cell and the checkbox. To create what you want you will need to
check the value of the cell when the form is opened and set the value of the
checkbox accordingly. To do that double click on the form in the VB editor
to open the code for the userform. Select Userform in the left drop down and
activate in the right. Then put your code in the activate event procedure,
like this:

Private Sub UserForm_Activate()
If Range("Machnotice") = "X" Then
CheckMachineNotice = True
Else
CheckMachineNotice = False
End If

End Sub
HTH
Bob L
"john petty" wrote in message
...
Bob, I am using If/Then statements to set the values.
would it be cleaner to set a ControlSource?


-----Original Message-----
Getting the Checkbox values is done. The problem is that
when I reactivate the userform, I can now get the
Textboxes to show the data that was previously entered,
but the checkboxes that were previously checked are not
showing as checked (but the cells themselves have values

i.e
If CheckMachineNotice = True Then Range _
("MachNotice").value = "X"

When the form is reactivated, the data in Range
MachNotice
is there but the checkbox does not reflect that anything
has been done (i.e. false)


-----Original Message-----
John,
I'm not following you. You can also set checkbox
values using the
activate event of the user form. For example, if the
checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
.. .
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




.



.



.

.

and Whalla. Thanks Bob. You MVP's are the best.
-----Original Message-----
If you use controlsource it is going to put true or false
in the cell rather
than an X like you are doing. Doing it your way there is
no direct linkage
between the cell and the checkbox. To create what you
want you will need to
check the value of the cell when the form is opened and
set the value of the
checkbox accordingly. To do that double click on the
form in the VB editor
to open the code for the userform. Select Userform in the
left drop down and
activate in the right. Then put your code in the
activate event procedure,
like this:

Private Sub UserForm_Activate()
If Range("Machnotice") = "X" Then
CheckMachineNotice = True
Else
CheckMachineNotice = False
End If

End Sub
HTH
Bob L
"john petty" wrote in message
...
Bob, I am using If/Then statements to set the values.
would it be cleaner to set a ControlSource?


-----Original Message-----
Getting the Checkbox values is done. The problem is
that
when I reactivate the userform, I can now get the
Textboxes to show the data that was previously entered,
but the checkboxes that were previously checked are not
showing as checked (but the cells themselves have
values

i.e
If CheckMachineNotice = True Then Range _
("MachNotice").value = "X"

When the form is reactivated, the data in Range
MachNotice
is there but the checkbox does not reflect that
anything
has been done (i.e. false)


-----Original Message-----
John,
I'm not following you. You can also set checkbox
values using the
activate event of the user form. For example, if the
checkbox is named
checkbox1, the event procedure



Private Sub UserForm_Activate()
Me.CheckBox1 = False
End Sub

will always make it false.

"John Petty" wrote in message
.. .
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
news:1b8d01c3869e$45b54c10
...
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




.



.



.

.



.