I have a Userform which has a one Multipage with a spreadsheet and one Frame
with two Textboxes. At the moment I have a value which is displays on the
spreadsheet (say A1) and the same value also displayed on one of the Textbox.
But when I close the programme down, it does not save any data that has
changed, it returns the original values. How do I go about sorting this out?
--
KK

did you choose to save the workbook when you closed the programme down. All
data is saved in the file for the workbook.

further exploring, when you update the value in the textbox which displays
the value in A1, does the value in A1 change to match? If not, is
calculation set to manual?

--
Regards,
Tom Ogilvy


"KK" wrote in message
...
I have a Userform which has a one Multipage with a spreadsheet and one
Frame
with two Textboxes. At the moment I have a value which is displays on the
spreadsheet (say A1) and the same value also displayed on one of the
Textbox.
But when I close the programme down, it does not save any data that has
changed, it returns the original values. How do I go about sorting this
out?
--
KK

I think the problem lies in the code to save the workbook before closing. Can
you give me an exemple so that I can see were I'm going wrong?
--
KK


"Tom Ogilvy" wrote:

did you choose to save the workbook when you closed the programme down. All
data is saved in the file for the workbook.

further exploring, when you update the value in the textbox which displays
the value in A1, does the value in A1 change to match? If not, is
calculation set to manual?

--
Regards,
Tom Ogilvy


"KK" wrote in message
...
I have a Userform which has a one Multipage with a spreadsheet and one
Frame
with two Textboxes. At the moment I have a value which is displays on the
spreadsheet (say A1) and the same value also displayed on one of the
Textbox.
But when I close the programme down, it does not save any data that has
changed, it returns the original values. How do I go about sorting this
out?
--
KK