In VBA at least any 'difference' is absent; see also the locals window.Code:Sub M_snb() Dim x00 As String, x01 As String, x02, x03 x00 = Format(1234) x01 = Format$(1234) x02 = Format(1234) x03 = Format$(1234) x04 = Format(1234) x05 = Format$(1234) MsgBox VarType(x00) & vbTab & TypeName(x00) & vbLf & VarType(x01) & vbTab & TypeName(x01) & vbLf & VarType(x02) & vbTab & TypeName(x02) & vbLf & VarType(x03) & vbTab & TypeName(x03) & vbLf & VarType(x04) & vbTab & TypeName(x04) & vbLf & VarType(x05) & vbTab & TypeName(x05) End Sub
Of course in the local window only x00 and x01 are 'real 'strings'.




Reply With Quote
Bookmarks