?
Solved

Excel 2007 ShapeStyle presets

Posted on 2014-02-27
2
Medium Priority
?
618 Views
Last Modified: 2014-02-28
I have a shape which starts off as

oBlock1.ShapeStyle = msoShapeStylePreset23

I want to programmatically make that have a Thick Black Border, but without altering the Fill Style of light blue.

When I do that with
oBlock1.ShapeStyle = msoShapeStylePreset1
The Fill Style changes to White :(

How can I only alter the Border?

Thanks experts!
0
Comment
Question by:hindersaliva
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39894100
Hi,

Since the Stylepresets are pre-set

pls try

    oBlock1.ShapeStyle = msoShapeStylePreset23
    oBlock1.Line.Weight = 3
    oBlock1.Line.ForeColor.RGB = vbBlack

Open in new window

Regards
0
 

Author Comment

by:hindersaliva
ID: 39894267
Hey thanks Rgonzo. That works for me :)
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question