J
john petty
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
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