View Single Post
Old 17-08-2010, 21:01
PAnderson PAnderson is offline
Join Date: Nov 2003
Posts: 47

Originally Posted by runflacruiser View Post
This could be happening when you are passing a value or object to a function and the value is not set.
Example: You have to have something selected in order to run the macro. Selected item also passed to function.
Make sure all of your variables are being set.

Nothing has to be selected. All you do is click a button and it creates the shape.

I finally was able to get the error again. When I click Debug it goes to this lines in Alex's code:

Private Function HexVal(ByVal strHex) As Long
    HexVal = Val("&h" & strHex)
End Function
I'm wondering if I need to break up some of the string codes onto separate lines with the & _ Shelby suggested. Although when it works, the shapes are created just fine. ???

Reply With Quote