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.
Jump to Post'is there any code like this?
userform1.input_date.value = userform1.input_date.lastValueNope.. 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 …
'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, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.