how do you circle an item on an excel document

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
 
J

Jim Thomlinson

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...
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top