How do I check values of variables in a macro? Home Board Archive Index Excel VBA How do I check values of variables in a macro? Posted by Newbie on November 07, 2001 8:29 AM Question as per subject line...Newb. Posted by Dan on November 07, 2001 8:49 AM How about just inserting the value in to a cell? i.e. Range("A1").value = VariableName Posted by Anon on November 07, 2001 2:44 PM Or .... MsgBox VariableName.Value