Userforms

[Phill Sheen]

Hi,
I was wondering if anyone could help me.
I have created a spreadsheet the uses a userform to input data into a spread
sheet. So when the user wants to input data they press a button on the
spread sheet, the user form pops up, they fill in the required text boxes
and listboxes and press a button on the userform that fills in the required
cells with the data required.
The only problem is if they then want to update the data, when they bring up
the userform a second time all the textboxes and listboxes are empty so they
have to fill them all in for scratch.
How can I get it to save the changes make in the Userform?

Thanks for any help anyone one can give.

Phill

 

[DennisE]

Phil,

To redisplay the userform with the data
still in it, use the Hide method rather than
unloading it.

-- Dennis Eisen