Code:
Option Explicit
Dim strName As String
Private Sub_text1()
strName = " "
end sub
You should put option explicit at the front of your code, then it will give you hell if you have something undeclared,
and use the same name for the string as the one you declARed, don't declard it strName and use the name "Name" cause it will not work.