Feb 23 2020 05:45 PM
Can we actually make a textbox data from a userform not editable when it is transferred to a column? I have a textbox that collects current date and time when it's being submitted. When submitting the userform, user will not be able to write or select the current date as it comes automatically (Refer photo below).
With txtdateac
txtdateac.Text = Format(Now(), "DD/MMM/YYYY/HH/NN/AM/PM")
End With
However, user can change the date and time after it has been submitted. The only way I can think of is to lock the cells for editing.
Are there any options besides locking the column? Thanks for your support!