0

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.

2
Contributors
2
Replies
9
Views
4 Years
Discussion Span
Last Post by imBaCodes
1

'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

1

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
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.