VBA to set shape outline color from variable
I have a shape created and am looking to set the color based on a RGB value stored in variable.
Data in H2: RGB(0,255,255)
I'm getting a Run-time error '13': Type Mismatch.HTML Code:
The debug.print shows "RGB(0, 255, 255)" (without quotes).
If i replace the variable MyColor and manually type in RGB(0, 255, 255) it works just fine.
I also tried to Dim my variable as long, but that also failed, at copying the value in H2.
Last edited by Remotruker; 05-08-2020 at 10:41 AM.
Thanks. I must be missing the relevance. I am trying to take a value from a cell and store it into a variable. Whereas the referenced post is providing the values directly within VBA code.
If i provide the values directly i the vba code(eliminating the variable), it works fine.
Originally Posted by porucha vevrku
Last edited by Remotruker; 05-08-2020 at 10:24 AM.
You have read this topic not very carefully - look below:
Please Login or Register to view this content.
You are still defining the values within the VBA Code.
andPlease Login or Register to view this content.
I have resolved my issue by defining 3 variablesPlease Login or Register to view this content.
and calling them in the ForeColor:Please Login or Register to view this content.
Please Login or Register to view this content.
You still read "this" not very carefully - these 'RGB' values in the code are only for color reset for shapes for visual testing, so that you can easily see what happens during code execution. The correct values are taken from the worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks