Check Characters On Enter

This part is about the way to check as soon as completing to input characters by using utility function to check characters like Utility Function To Check Entered Characters.

Check in a moment if input characters are all One-byte upper alphabet characters.

For example, there is the case user wants to check if input characters are One-byte upper alphabet or not as soon as completing to input. In this case, it is possible to check with below assembled functions in CELF.

  1. Create action set to start when cell value is changed.
../../../_images/img_01.en232.png
  1. Get characters by using INDIRECT function which introduced Run Action Set when Cell Value Changed.
../../../_images/img_02.en217.png
  1. Check if value 2 is One-byte upper alphabet character or not by presuming a parameter of UTIL.ISCHARTYPE function.
../../../_images/img_03.en181.png

Those are functions which are used above.

../../../_images/img_04.en153.png

See also

You can check a lot of type of characters by changing character type number of function. And also, there are some other utilities to check other characters. Refer Utility Function Of Check Entered Characters.