PDA

View Full Version : Solved: UserForm Text Box to Retain Data



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

Bob Phillips
02-24-2008, 11:41 AM
Save the data to Excel names, and hide the names.

sooty8
02-25-2008, 02:28 AM
Thanks XLD

I'm a numpty never thought of that one!!

Cheers

Sooty8