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

Quote:
Originally Posted by runflacruiser View Post
Hi.
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.

-John
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:

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. ???

Patti
Reply With Quote