How to Prevent Textbox Manual Entry On UserForm

[Rajeshkumar R]

Dear Friends,

In a Userform I have a Textbox Named As “Textbox8” next to that I have a command button Named as “CommandButton4”

CommandButton4 basically linked with another userform i.e. calendar; So my intention is any user must select date by clicking “CommandButton4”; calendar will Pop up and once the date chosen same will be reflecting in “Textbox8”; which is Perfectly working Fine for me.

The Support I am looking here is: -

How to prevent any user not to enter textbox8 manually?

How to guide (or) communicate them to click on adjacent Command button (Calendar Image already Loaded on it) to update Textbox8?

Looking forward your valuable suggestion!

Thanks & Regards,
Rajeshkumar R

[6StringJazzer]

Set the Textbox8 Enabled property to False. This will allow display of the textbox, and code can put values in it, but the user cannot put values in it. You can do this in code or in the form designer. Another option is to use a Label instead of a Textbox, which is what I prefer in these situations.

The placement of the calendar button should be intuitive to the user but you can add a Label above the textbox that says "Click button to select date"

[dorabajji]

You can use locked property set to true.

[6StringJazzer]

You can use locked property set to true.

This is the best answer, I had not known about this.

[Rajeshkumar R]

Dear 6StringJazzer/dorabajji,

Noted, Thanks a lot for your instant input.

Thanks & Regards,
Rajeshkumar R