VBA Combo Box in Excel SpreadSheet Inserting VBA Combo Box (ActiveX Control) The VBA ComboBox is a drop-down list that you can use in Excel. Remember, that this is not the same type of list that you can enter in Excel for data correctness. As in the case of a […]
1. CVar VBA function – Description The CVar VBA function returns a value with the Variant data type . The Variant data type can store both numeric and text data. When using this function, remember that the Variant data type itself is the least efficient data type in VBA. 2. […]
1. CStr VBA function – Description The CStr VBA function returns a value of the String data type . The simplest form of the String data type with a variable number of characters takes up as many bytes in memory as there are characters in a given text string. We […]
1. CSng VBA Function – Description The CSng VBA function returns a value with the Single data type . It is a number between -3.402823e38 and 1.401298e45 . The Single data type is 4 bytes in memory. We usually use functions when we want our data to be more efficient. […]
1. CLngLng VBA function – Description The CLngLng VBA function returns a value of the LongLong data type . It is an integer ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 . The LongLong data type is 8 bytes in memory. It is important that the LongLong data type itself, unlike the Long […]
1. CLng VBA function – Description The CLng VBA function returns a value of the Long data type . It is an integer in the range –2,147,483,648 to 2,147,486,647 . The Long data type is 4 bytes in memory. The function can also be used to convert a number stored […]