+ Reply to Thread
Results 1 to 1 of 1

Curiosity: Trying to assign Border Properties to a Style

  1. #1
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Curiosity: Trying to assign Border Properties to a Style

    I came across a quirk for defining Styles in VBA. If I create a new blank style then assign properties to it from a range, everything works EXCEPT Borders. It seems that setting a Style's Border properties from a range requires using the BasedOn parameter for Styles.Add. I'm in the Office Insider's Program at home, and that may have something to do with this. Has anyone else come across this? I don't use Styles much, so this is new for me.

    Run the foo macro in the attached workbook to see what happens.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy to & apply style from another document - not all properties depend on style
    By kofeincek in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2020, 09:35 PM
  2. [SOLVED] Change Cell border Style with a Macro
    By zealot in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-28-2017, 07:17 PM
  3. Outline Border Shortcut, changeing the properties
    By jwongsf in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-02-2016, 07:48 PM
  4. Format marker - dash style, border width, etc.
    By buran in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-03-2010, 08:10 AM
  5. excel 2007 frame border style
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2009, 03:48 AM
  6. [SOLVED] Change default border style?
    By kyot58 in forum Excel General
    Replies: 0
    Last Post: 02-27-2006, 02:10 PM
  7. [SOLVED] Checking for the border style of a range
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2006, 05:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1