Member Avatar

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
  • 109 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by imBaCodes

Recommended Answers

All 2 Replies

Member Avatar

'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

Member Avatar

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, learning, and sharing knowledge.