Case sensitive problem
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
When I attempt to write the string "true" out to an excel spreadsheet from a VBA user form, "true" is spelled in all caps "TRUE." Any help would be much appreciated. Thanks in advance. D
Probably because it's being interpreted as a binary value. Put a
'character before the "t" in "true", like this: someCellReference.Value = "'true". This tells Excel that the value should be interpreted as a string. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome