When do I use double quotes in spBasic?
When to use double quotes, e.g., “myString”, 1) You don’t have to use quotes in spBasic variable value cells (the cells to the right of the variable names). The cell contents will automatically be interpreted as a string without having to use quotes. If you put quotes in, the quotes will become part of the string. 2) Use quotes in spBasic statement expressions where a literal string is needed, e.g, astr = “Hello” 3) If you want a number to be a string, you can a – put a single quote mark ‘ before the number b – reformat the variable value cell (the cell to the right of the variable name) to ‘Text’ format. Do this by selecting the cell, right click on it, and chose ‘Format Cells’. Then select the ‘Number’ tab, select ‘Text’, then press OK. Some of my Excel expressions do not work when I use spBasic variables. Make sure the spBasic variable value cells (the cells to the right of the variable names) are formatted as ‘General’. If they are formatted as ‘Text’ you may get errors. See the qu
