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.

Recommended Answers

All 2 Replies

'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

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.