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 submitted. When submitting the form, user will not be able to write or select any date as it comes automatically. (Refer photo below).
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!