You can examine the contents of sheet objects by specifying the object and using row and column to identify a "cell" similar to what you might do with a spreadsheet macro. Here's an example:
'that GetCell argument is row,column
If Err.number<>0 then
msgbox("Error getting TOTAL value")
'remove editing characters and convert text to a number
The example shows a method for removing a % character. You don't need to do that if your cell contains a number and nothing else.