 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Borders
Hello to all, I have a range of cells C34:N35 I need VBA code in order to have borders for this range or clearing the borders depending on the checkbox if it is cliked or not. ie. The code will be part of CheckBox2 button with condition to show the border or hide them.The sheet is protected. Homework?  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hello to all, > I have a range of cells C34:N35 > I need VBA code in order to have borders for this range or clearing the > borders depending on the checkbox if it is cliked or not. > ie. The code will be part of CheckBox2 button with condition to show the > border or hide them.The sheet is protected. NOT homework! I was able to show / hide the numbers inside the range according to the check box by changing the color to white and then black again. It didn't look nice to have borders for empty cells! so the idea came to not see the borders. I recorded the macro and it has (i think) seven line which looks too long. Thanks to both of you. > Homework? > [quoted text clipped - 4 lines] >> ie. The code will be part of CheckBox2 button with condition to show the >> border or hide them.The sheet is protected. You can adapt this to make the borders Sub bordersaround() Worksheets("Sheet1").Range("A1:D4").BorderAround _ ColorIndex:=3, Weight:=xlThick 'Selection.bordersaround End Sub or this to erase them Sub noborders() Worksheets("Sheet1").Range("A1:D4") _ .Borders.LineStyle = xlNone End Sub SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > NOT homework! > I was able to show / hide the numbers inside the range according to the [quoted text clipped - 13 lines] >>> ie. The code will be part of CheckBox2 button with condition to show the >>> border or hide them.The sheet is protected. Thanks! I was always interestred in spliting the line in VB code which is seen as _ . What key combination does this????? > You can adapt this to make the borders > [quoted text clipped - 29 lines] >>>> ie. The code will be part of CheckBox2 button with condition to show >>>> the border or hide them.The sheet is protected. That is the underscore character. SHIFT + - (hyphen) Make sure you have a <space> between last character and the underscore _ Gord Dibben MS Excel MVP >Thanks! >I was always interestred in spliting the line in VB code which is seen as _ [quoted text clipped - 34 lines] >>>>> ie. The code will be part of CheckBox2 button with condition to show >>>>> the border or hide them.The sheet is protected. Thanks > That is the underscore character. SHIFT + - (hyphen) > [quoted text clipped - 43 lines] >>>>>> ie. The code will be part of CheckBox2 button with condition to show >>>>>> the border or hide them.The sheet is protected. Hi, Record the code to turn on and off the borders and put it inside the Checkbox_Click procedure. SignatureCheers, Shane Devenshire > Hello to all, > I have a range of cells C34:N35 > I need VBA code in order to have borders for this range or clearing the > borders depending on the checkbox if it is cliked or not. > ie. The code will be part of CheckBox2 button with condition to show the > border or hide them.The sheet is protected.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.