Excel in a Tablet Question

A friend has a tablet with excel on it. He is able to draw object in excel.

I wanted to used the macro recorder to record the steps he used, and it
doesn't record any hand drawn operations such as drawing circles, lines, arcs.

Does any one know I we can record those operations???

That would help me in writing VBA code to check the objects color and
determine if it needs to be visible or invisible.

Thanks,

Gary

You can record the selection of the completed object (Oval 5 here), and the
setting of it's properties, as:

Sub CheckShape()

ActiveSheet.Shapes("Oval 5").Select
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)

End Sub

hth
Vaya con Dios,
Chuck, CABGx3



"Gary" wrote:

> A friend has a tablet with excel on it. He is able to draw object in excel.
>
> I wanted to used the macro recorder to record the steps he used, and it
> doesn't record any hand drawn operations such as drawing circles, lines, arcs.
>
> Does any one know I we can record those operations???
>
> That would help me in writing VBA code to check the objects color and
> determine if it needs to be visible or invisible.
>
> Thanks,
>
> Gary

We were not able to see any any except for the standard stuff for a blank
macro from the recorder.

This is what we did:
1) Under Test - Macro - we turn the macro record on
2) He then use the pen for the tablet (win xp for tablet) to draw lines,
copy and paste a circle (already on the form).
3) He then turn off the recorder and view the created macro.

We didn't see anything like what you are saying. I do see that when I use
my mouse with a desk top system.

Any help here??

Gary

"CLR" wrote:

> You can record the selection of the completed object (Oval 5 here), and the
> setting of it's properties, as:
>
> Sub CheckShape()
>
> ActiveSheet.Shapes("Oval 5").Select
> Selection.ShapeRange.Fill.Visible = msoTrue
> Selection.ShapeRange.Fill.Solid
> Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13
> Selection.ShapeRange.Fill.Transparency = 0#
> Selection.ShapeRange.Line.Weight = 0.75
> Selection.ShapeRange.Line.DashStyle = msoLineSolid
> Selection.ShapeRange.Line.Style = msoLineSingle
> Selection.ShapeRange.Line.Transparency = 0#
> Selection.ShapeRange.Line.Visible = msoTrue
> Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
> Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
>
> End Sub
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Gary" wrote:
>
> > A friend has a tablet with excel on it. He is able to draw object in excel.
> >
> > I wanted to used the macro recorder to record the steps he used, and it
> > doesn't record any hand drawn operations such as drawing circles, lines, arcs.
> >
> > Does any one know I we can record those operations???
> >
> > That would help me in writing VBA code to check the objects color and
> > determine if it needs to be visible or invisible.
> >
> > Thanks,
> >
> > Gary

Sorry Gary, I don't have a tablet, so can't really see what you are
experienceing. I do know however, that there are many other things that the
Macro Recorder will not record, even under normal conditions. I did not
mean to suggest in my post that you should be able to do it. I only
suggested a method of committing the Object name and properties to a macro
after the object had been drawn. I apologize if I mis-led you.

Vaya con Dios,
Chuck, CABGx3





"Gary" <Gary@discussions.microsoft.com> wrote in message
news:C07BC5F4-82FF-4CF0-AECF-AD0282D8D2F5@microsoft.com...
> We were not able to see any any except for the standard stuff for a blank
> macro from the recorder.
>
> This is what we did:
> 1) Under Test - Macro - we turn the macro record on
> 2) He then use the pen for the tablet (win xp for tablet) to draw lines,
> copy and paste a circle (already on the form).
> 3) He then turn off the recorder and view the created macro.
>
> We didn't see anything like what you are saying. I do see that when I
use
> my mouse with a desk top system.
>
> Any help here??
>
> Gary
>
> "CLR" wrote:
>
> > You can record the selection of the completed object (Oval 5 here), and
the
> > setting of it's properties, as:
> >
> > Sub CheckShape()
> >
> > ActiveSheet.Shapes("Oval 5").Select
> > Selection.ShapeRange.Fill.Visible = msoTrue
> > Selection.ShapeRange.Fill.Solid
> > Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13
> > Selection.ShapeRange.Fill.Transparency = 0#
> > Selection.ShapeRange.Line.Weight = 0.75
> > Selection.ShapeRange.Line.DashStyle = msoLineSolid
> > Selection.ShapeRange.Line.Style = msoLineSingle
> > Selection.ShapeRange.Line.Transparency = 0#
> > Selection.ShapeRange.Line.Visible = msoTrue
> > Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
> > Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
> >
> > End Sub
> >
> > hth
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Gary" wrote:
> >
> > > A friend has a tablet with excel on it. He is able to draw object in
excel.
> > >
> > > I wanted to used the macro recorder to record the steps he used, and
it
> > > doesn't record any hand drawn operations such as drawing circles,
lines, arcs.
> > >
> > > Does any one know I we can record those operations???
> > >
> > > That would help me in writing VBA code to check the objects color and
> > > determine if it needs to be visible or invisible.
> > >
> > > Thanks,
> > >
> > > Gary