+ Reply to Thread
Results 1 to 3 of 3

Can't Change Visibility of Shapes Border Lines with Toggle Button

  1. #1
    Registered User
    Join Date
    09-09-2016
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    2

    Can't Change Visibility of Shapes Border Lines with Toggle Button

    Hey Guys, I just started working with VBA and I got a problem I can't find the answear to.

    This is how it should function: You click on a shape, that works like a toggle button, to change the visibility of another shapes border lines from Visible to Not visible and the other way round.
    I found a code that changes the text inside a shape when you press a toggle button and adapted it to the shape in my sheet. This is how it looks like :

    Please Login or Register  to view this content.
    If tried hours to adapt it to work the way i want but i can't find a solution, because my knowledge is way to low.
    Could anybody tell me how i have to change the code to work the way i want ?
    Thank you

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Can't Change Visibility of Shapes Border Lines with Toggle Button

    Hello welcome to the forum.

    This code would toggle the border of Rectangle 1 between none and green line:

    Please Login or Register  to view this content.
    Can you adapt something like this?

    DBY

  3. #3
    Registered User
    Join Date
    09-09-2016
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    2

    Re: Can't Change Visibility of Shapes Border Lines with Toggle Button

    Thank you for your fast answear ! This absolutely solves the problem ! thank you very much !

+ 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. [SOLVED] Removing the Focus Dash Border around Text in Toggle Button???
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2016, 10:38 AM
  2. Toggle button to change values in several tables
    By dzek in forum Excel General
    Replies: 1
    Last Post: 06-03-2014, 03:17 PM
  3. [SOLVED] Toggle visibility of shapes via dropdown list between workbooks
    By GuyL23 in forum Excel General
    Replies: 1
    Last Post: 03-07-2014, 07:11 AM
  4. Button to toggle visibility of all ovals on active sheet
    By apathetic in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-19-2013, 12:27 AM
  5. Using Toggle Button to hide/unhide rows that may change
    By jmpatrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 09:48 AM
  6. Toggle checkbox visibility
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2010, 07:38 PM
  7. Toggle change control button face id & caption
    By jpexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2009, 08:05 AM

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