In VB or VBA programming, when defining variables, Integer can be defined as integer, and sometimes integer can be directly replaced by%, which saves trouble; Character variables are defined as strings, which can also be replaced by $; Double-precision variables are defined as double, and can also be replaced by #. For example, for example, before we use an integer variable I to perform four operations of addition, subtraction, multiplication and division, we must first define it, which is written in VB code: Dim i As Integer, or Dim i%, equivalent (with the same meaning).