How to Restore the last input in form open?

Question

imBaCodes 2

5 Years Ago

Hi,
i have a form and i have 2 input box.
Is there any way to restore the last input in reopening the Form.

'is there any code like this?
userform1.input_date.value = userform1.input_date.lastValue

Thank you in advance.

visual-basic-6

2 Contributors
2 Replies
16 Views
5 Years Discussion Span
Latest Post 5 Years Ago by imBaCodes

Jx_Man 987

5 Years Ago

'is there any code like this?
userform1.input_date.value = userform1.input_date.lastValue

Nope.. I don't think it exist

i have a form and i have 2 input box.
Is there any way to restore the last input in reopening the Form.

You can save it into text file and access it whenever you need

imBaCodes 2 · Answer 1 · 2013-04-05T05:08:32+00:00

Thank you i fixed it. there is a way. i used this code :

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = 0 Then

        Last_value = Metering_Program.Input_date1.Value
        last_value2 = Metering_Program.Input_Date2.Value

    End If
End Sub