textbox

How to force proper case in textbox

Proper Text is nothing but each word will have it's first letter in caps. If you want to change every first letter of each word in a sentence then you can use StrConv function of VB in VBA. Syntax: String(Mandatory) String is the String which you want to make in Proper Case. Conversion as StrConv(Mandatory): This is set of Conversion [...]

How can I force input to Uppercase or Lowercase in a Textbox

At some point of time you may need user to force to Enter in a particular Case in your Excel Macro Text Box. It could be either in a Lower Case or Upper Case. Unfortunately in VBA Text Box, you don't have any inbuilt settings to do so. However by writing few lines code under Textbox Change Event , you [...]