Prev: How do you change the preset borders on the Formating Tool bar?
Next: Consolidate
From: KNOWAK on 5 Feb 2010 15:57
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
From: Dan on 5 Feb 2010 16:11
I found this link:

http://office.microsoft.com/en-us/help/HA102083161033.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
From: Jim Thomlinson on 5 Feb 2010 16:15
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
From: Gord Dibben on 5 Feb 2010 17:00
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
<James_Thomlinson(a)owfg-Re-Move-This-.com> 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...

 | 
Pages: 1
Prev: How do you change the preset borders on the Formating Tool bar?
Next: Consolidate