ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2 questions again (https://www.excelbanter.com/excel-programming/278527-2-questions-again.html)

john Petty

2 questions again
 
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


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com