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.
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.
'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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.