Checking for a Text Selection Length

There are numerous times when you are writing macros when you will need to determine if the user has made a selection. There are numerous ways you can do this in a macro. The following code illustrates on possible method for accomplishing this in VBA. It sets the value of a flag, InSelection, to True if there is currently a selection. Otherwise InSelection is set to False.

InSelection = False
If Len(Selection) > 0 Then InSelection = True

The technique used here relies on the fact that if a selection has been made, it will have a length. This length is returned by the Len function of VBA.