CSng « Data Type Functions « VBA / Excel / Access / Word






1.To avoid the Type Mismatch error, use the built-in CSng function to convert the string stored in the value1 variable to a Single type number
2.CSng() converts value to Single