Is it possible to have rounded corners in cells with borders.

  • Thread starter Thread starter Ronnie
  • Start date Start date
R

Ronnie

Just wondered if there is any way to have rounded corners in highlighted
cells.
I am making up a spreadsheet and the Date box etc and it would look better
with rounded corners.
Any help is appreciated if not are there any good Freeware invoice design
software programs about.
Thanks in Advance Ron
 
Not for the cells (and using gridlines or borders).

But you could apply some shape from the drawing toolbar. Although, I would only
use this on a few cells.
 
Ronnie

Sub RoundRectangle()
Dim x, y As Single, area As Range
For Each area In Selection.Areas
With area
x = .Height * 0#
y = .Width * 0#
ActiveSheet.Rectangles.Add Top:=.Top - x, Left:=.Left - y, _
Height:=.Height + 1 * x, Width:=.Width + 1 * y
End With
With ActiveSheet.Rectangles(ActiveSheet.Rectangles.Count)
.Interior.ColorIndex = xlNone
.ShapeRange.AutoShapeType = msoShapeRoundedRectangle
End With
Next area
End Sub

Will place a transparent rounded rectangle over a cell or selection of cells.

Cell background colors are maintained if any.

Gord Dibben Excel MVP
 
Back
Top