Clearing a diagonal line in a cell

B

Bill

I'm using an Excel worksheet to demonstrate subtraction (with "borrows") to my Maths students. I have a button which crosses out a digit (in a cell), ready to reduce the digit by 1
I can't code the worksheet to clear the "diagonal cell line", ready for the next example
Sounds complicated! but I would appreciate some assistance
thank
Bill
 
J

Jim Rech

Perhaps:

With Selection
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
End With


--
Jim Rech
Excel MVP
| I'm using an Excel worksheet to demonstrate subtraction (with "borrows")
to my Maths students. I have a button which crosses out a digit (in a cell),
ready to reduce the digit by 1.
| I can't code the worksheet to clear the "diagonal cell line", ready for
the next example.
| Sounds complicated! but I would appreciate some assistance.
| thanks
| Bill
 
B

Bill

thanks Jim, will try

Bill

----- Jim Rech wrote: -----

Perhaps:

With Selection
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
End With


--
Jim Rech
Excel MVP
| I'm using an Excel worksheet to demonstrate subtraction (with "borrows")
to my Maths students. I have a button which crosses out a digit (in a cell),
ready to reduce the digit by 1.
| I can't code the worksheet to clear the "diagonal cell line", ready for
the next example.
| Sounds complicated! but I would appreciate some assistance.
| thanks
| Bill
 
Top