how do you circle an item on an excel document

  • Thread starter Thread starter KNOWAK
  • Start date Start date
K

KNOWAK

i HAVE A FORM THAT I AM USING CREATED IN EXCEL. I NEED TO CIRCLE A NUMBER
PRESENTED ON THE FORM. HOW DO I CIRCLE A NUMBER ON THE FORM WITH EXCEL
 
Open up the drawing toolbar and drag an oval on your spreadsheet.

Tools | Customize | Toolbars -> check Drawing Toolbar
on the drawing toolbar is an icon with an oval on it. Click that button.
Your cursor will turn into a cross hair. Place the crosshai in the corner of
the cell you want to circle and while holding down the mouse button drag the
cursor to create your circle...
 
If you have many of these to do you can select multiple cells using CTRL +
Click then run this macro.

Sub My_Circle()
Dim X, Y As Single, area As Range
'rotate through areas - this allows multiple circles to be drawn
For Each area In Selection.Areas
With area
' x and y are numbers that are a function of the
' area's height and width
X = .Height * 0.1 'adjust to suit
Y = .Width * 0.1 'adjust to suit
ActiveSheet.Ovals.Add Top:=.Top - X, Left:=.Left - Y, _
Height:=.Height + 2 * X, Width:=.Width + 1.5 * Y
ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _
.Interior.ColorIndex = xlNone
End With
Next area
End Sub


Gord Dibben MS Excel MVP
 
Back
Top