Limit Character Length in a Userform Textbox

In Userform1 I have several textbox and one commandbutton1. If I mouseclick on a textbox and click commandbutton1 the letters YES is entered in the texbox. To prevent double click entry into the same textbox I set the maximum length property at 3. However, setting the maximum length to 3 does not work. Subsequent commandbutton1 clicks will result in an infinite YES entries.

Is the maximum length property disabled when commandbutton entries are applied?

Thank you,
Gal403

SAMPLE 2.xlsm

Thank you Andy. I'm familiar with the code you suggested. I've attached a sample userform as an example. As you can see, I can enter an infinite combination of fruit in the textbox. My fear is a user can enter multiple entries in any given textbox when I only require the user to enter a single commandbutton click. Using my existing code I'm note sure if a code should be placed in the textbox limiting a single entry; or a code in each command button that will only allow a single click.

If the user needs to retract the entry then I will need to create a fourth command button that will clear the textbox that has focus.

Gal

Andy, that was brilliant! Thank you very much