Userform-Transferred Data must not be editable

%3CLINGO-SUB%20id%3D%22lingo-sub-1189949%22%20slang%3D%22en-US%22%3EUserform-Transferred%20Data%20must%20not%20be%20editable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189949%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20we%20actually%20make%20a%20textbox%20data%20from%20a%20userform%20not%20editable%20when%20it%20is%20transferred%20to%20a%20column%3F%20I%20have%20a%20textbox%20that%20collects%20current%20date%20and%20time%20when%20it's%20being%20submitted.%20When%20submitting%20the%20userform%2C%20user%20will%20not%20be%20able%20to%20write%20or%20select%20the%20current%20date%20as%20it%20comes%20automatically%20(Refer%20photo%20below).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mr_Buttons_0-1582505730197.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172872iAD7A4770518C5027%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Mr_Buttons_0-1582505730197.png%22%20alt%3D%22Mr_Buttons_0-1582505730197.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3EWith%20txtdateac%0A%20%20%20%20txtdateac.Text%20%3D%20Format(Now()%2C%20%22DD%2FMMM%2FYYYY%2FHH%2FNN%2FAM%2FPM%22)%0A%20%20%20%20End%20With%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EHowever%2C%20user%20can%20change%20the%20date%20and%20time%20after%20it%20has%20been%20submitted.%20The%20only%20way%20I%20can%20think%20of%20is%20to%20lock%20the%20cells%20for%20editing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20any%20options%20besides%20locking%20the%20column%3F%20Thanks%20for%20your%20support!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189949%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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).

 

Mr_Buttons_0-1582505730197.png

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!

0 Replies