Results 1 to 10 of 15

Thread: Macro to produce Thick Border Box

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Did you use the macrorecorder ?

  2. #2
    Member
    Join Date
    Aug 2012
    Posts
    40
    Rep Power
    0
    Thanks for the reply

    I did use a macro recorder, but not sure how to have the thick Border Box aroond the values in the same row where the text in Col, A is highlighted
    I have attempted to write code but need help in completing this

    Will most propably have to have this as a Private Sub to be copied in the code for the applicable sheet

    Code:
    Sub Borders ()
    
    If Text.bold = True 
    Then  ?????
    
    With Selection.Borders(xlEdgeLeft)
             .LineStyle = xlContinuous
    
    
    Else 
    Exit Sub
    next 
    
    End with
    End Sub
    Your assistance in resolving this is most appreciated

Similar Threads

  1. List box tabbing
    By RedJames in forum Excel Help
    Replies: 1
    Last Post: 06-18-2014, 04:14 PM
  2. Replies: 3
    Last Post: 06-01-2013, 11:31 AM
  3. Excel VBA Macro To Open A File Through Browse Dialog Box
    By Safal Shrestha in forum Excel Help
    Replies: 2
    Last Post: 04-05-2013, 12:59 PM
  4. OpenFileDialog box malfunctions
    By hometech in forum Word Help
    Replies: 1
    Last Post: 10-22-2012, 04:15 PM
  5. Setting up a check box
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 08-07-2012, 08:26 AM

Posting Permissions

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