TextBox value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KK - 16 Jan 2006 17:52 GMT

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?

Signature

Reply to this Message

Tom Ogilvy - 16 Jan 2006 18:13 GMT

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?

Signature

Regards,
Tom Ogilvy

> 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?

Reply to this Message

KK - 21 Jan 2006 20:09 GMT

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?

Signature

> did you choose to save the workbook when you closed the programme down. All
> data is saved in the file for the workbook.
[quoted text clipped - 11 lines]
> > changed, it returns the original values. How do I go about sorting this
> out?

Reply to this Message