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

I found this link:

http://office.microsoft.com/en-us/he...083161033.aspx

"KNOWAK" wrote:

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

Jim Thomlinson


"KNOWAK" wrote:

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

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

On Fri, 5 Feb 2010 13:15:01 -0800, Jim Thomlinson
wrote:

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