Chapter Summary

• String case can be managed with UCase and LCase functions.

• Strings can be extracted from other strings using functions such as Left, Right, and Mid.

• Strings can be searched and compared with VBA functions InStr and StrComp, respectively.

• VBA supports a multitude of functions such as Date, Time, and Now for displaying dates and times

• Forms have a Timer event, which can be triggered automatically and regularly using the form's Timerlnterval property.

• Data is represented by both numbers and characters using character codes. VBA uses the Chr and Asc functions to convert between character codes and characters.

• Data such as strings, numbers, and date/time can easily be formatted using VBA's Format function.

0 0

Post a comment