Results 1 to 6 of 6

Thread: Excel special boarder Macro

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2011
    Location
    Canada
    Posts
    2

    Excel special boarder Macro

    Hi All,
    I am looking for MACRO to establish special Boarder to any selected Cells.
    Thanks

  2. #2
    Master Of Orion ForumAccount's Avatar
    Join Date
    Jan 2009
    Location
    Canada
    Posts
    2,802

    Re: Excel special boarder Macro

    Welcome to the forums.

    Contrary to popular belief, we are not psychics. We require actual information, context, and details to help you. We also generally look for a question to answer. You haven't provided any of those. Are you even using VB.NET? What version? What code did you try that isn't working?

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Excel special boarder Macro

    Welcome to the Forums.

    When you say "MACRO" that is a popular term of reference for a VBA Macro which is not VB.Net. Depending upon which language you are using we can move this thread if needed.

    You could start with recording a macro in Excel and using that however you need albeit in VBA or .Net
    http://www.vbforums.com/showthread.php?t=402032

    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  4. #4

    Thread Starter
    New Member
    Join Date
    Aug 2011
    Location
    Canada
    Posts
    2

    Re: Excel special boarder Macro

    Quote Originally Posted by RobDog888 View Post
    Welcome to the Forums.

    When you say "MACRO" that is a popular term of reference for a VBA Macro which is not VB.Net. Depending upon which language you are using we can move this thread if needed.

    You could start with recording a macro in Excel and using that however you need albeit in VBA or .Net
    http://www.vbforums.com/showthread.php?t=402032

    Thank you for your attention.
    I am usually use Excel 2007 and establish some MACROs to solve the application problem, I'm not using VB.NET and not familiar with VB, but some experience with VBA. I try to record the MACRO but it doesn't give me the result.
    Thanks

  5. #5
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Excel special boarder Macro

    Thanks for the clarifications.

    Thread Moved from VB.NET forum to Office Development forum

    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  6. #6
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Excel special boarder Macro

    Ok, what is the expected or desired action/result? Looks like you want a selected cell to become bolded or heavyweight border?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width