sooty8
02-24-2008, 07:30 AM
Hi All
We have about 20 textboxes on a userform -- 2 of them we only need to enter the data at the start of the working week as it is the same throughout the week. Is it possible for these 2 textboxes Tb1 & Tb2 to have the data entered and on closing & re-opening the userform the data is still there.
We could of course put the info on the sheet and the textboxes would read the sheet on opening the Userform -- the only trouble with that is we don't want anybody altering the info and messing up the rest of the sheets.
Perhaps a checkbox locking the textboxes Tb1 & Tb2 ??
Any help much appreciated
Regards
Sooty8
We have about 20 textboxes on a userform -- 2 of them we only need to enter the data at the start of the working week as it is the same throughout the week. Is it possible for these 2 textboxes Tb1 & Tb2 to have the data entered and on closing & re-opening the userform the data is still there.
We could of course put the info on the sheet and the textboxes would read the sheet on opening the Userform -- the only trouble with that is we don't want anybody altering the info and messing up the rest of the sheets.
Perhaps a checkbox locking the textboxes Tb1 & Tb2 ??
Any help much appreciated
Regards
Sooty8