Update default values

[fezzer]

Hi!

I have a form setup in Excel 97. One of it's functions is to input data into the spreadsheet. However when I go to the form again all the fields are clear even if I ask the form to place the values in the boxes:

S1TextPlace.Text = [Place]

Is there anyway I can update all these fields once the form opens so they appear on the form?

Thanks

Fez

 

[Zathras]

Easiest way is to use global (i.e. public) variables in a code module.

Public sTextPlace as String

Then in the form code you can use

  sTextPlace = S1TextPlace.Text

to capture the data before closing the form and use

  S1TextPlace.Text = sTextPlace

to restore the data after opening the form.