Office AutoShapes in VB?

[E Harris]

Hello all, and thanks in advance for any help.

I've inherited a PowerPoint application that needs some serious
retooling. It consists of one slide depicting a well and about 2
dozen text boxes that display fields from a "Well Construction" table
in a database. It hits a database and offers a user interface via VBA
code.

Currently, it only shows data. I want it to also be able to enter
data.

The natural way to do this would be to start in the top-right corner
and, using a TabIndex property, allow the user to cycle through all
fields in a logical order, entering data in each field.

Of course there's a snag-- from all my internet research, there's no
way to set anything like good ol' VB's TabIndex property for textboxes
on a PP slide. The VBA editor just doesn't list any proerties like
it.

This and other clunkiness makes me want to rebuild the program as a
stand-alone VB application. (Getting access to certain dialog boxes
is another reason).

This would solve all my problems except that I need the detail of the
PP slide-- namely the AutoShapes-generated diagram of the well. I
know I can save the slide as an image (.gif, jpeg) and then use a
picturebox to display that image in my VB program, but it never looks
as good as the original. (The diagram utilizes lots of textures and
shading.) It becomes even more fuzzy upon printing the form, which is
something this new VB app will need to do.

I know VB offers the shape control, but the limited fill styles don't
suit my needs.

So.... is there any way to get that AutoShape object that exists in
PowerPoint, Word, etc, onto a pure VB form? Some component or
reference I can add?

Thanks,

--E Harris

[Ronald]

- Start Visual Basic
- Click 'Project' - 'Components'
- Click on 'Insertable objects'

I'm sure you'll find here wat you need.
"E Harris" <re******@hotmail.com> wrote in message
news:15*************************@posting.google.co m...

Hello all, and thanks in advance for any help.

I've inherited a PowerPoint application that needs some serious
retooling. It consists of one slide depicting a well and about 2
dozen text boxes that display fields from a "Well Construction" table
in a database. It hits a database and offers a user interface via VBA
code.

Currently, it only shows data. I want it to also be able to enter
data.

The natural way to do this would be to start in the top-right corner
and, using a TabIndex property, allow the user to cycle through all
fields in a logical order, entering data in each field.

Of course there's a snag-- from all my internet research, there's no
way to set anything like good ol' VB's TabIndex property for textboxes
on a PP slide. The VBA editor just doesn't list any proerties like
it.

This and other clunkiness makes me want to rebuild the program as a
stand-alone VB application. (Getting access to certain dialog boxes
is another reason).

This would solve all my problems except that I need the detail of the
PP slide-- namely the AutoShapes-generated diagram of the well. I
know I can save the slide as an image (.gif, jpeg) and then use a
picturebox to display that image in my VB program, but it never looks
as good as the original. (The diagram utilizes lots of textures and
shading.) It becomes even more fuzzy upon printing the form, which is
something this new VB app will need to do.

I know VB offers the shape control, but the limited fill styles don't
suit my needs.

So.... is there any way to get that AutoShape object that exists in
PowerPoint, Word, etc, onto a pure VB form? Some component or
reference I can add?

Thanks,

--E Harris

[E Harris]

Thanks Ronald, but I had already tried that.

Don't thing anything that I think would be Office AutoShapes.

Thanks anyway.
"Ronald" <Ro****@nodom.nl> wrote in message news:<Yr**********************@amsnews02.chello.co m>...

- Start Visual Basic
- Click 'Project' - 'Components'
- Click on 'Insertable objects'

I'm sure you'll find here wat you need.
"E Harris" <re******@hotmail.com> wrote in message
news:15*************************@posting.google.co m...

Hello all, and thanks in advance for any help.

I've inherited a PowerPoint application that needs some serious
retooling. It consists of one slide depicting a well and about 2
dozen text boxes that display fields from a "Well Construction" table
in a database. It hits a database and offers a user interface via VBA
code.

Currently, it only shows data. I want it to also be able to enter
data.

The natural way to do this would be to start in the top-right corner
and, using a TabIndex property, allow the user to cycle through all
fields in a logical order, entering data in each field.

Of course there's a snag-- from all my internet research, there's no
way to set anything like good ol' VB's TabIndex property for textboxes
on a PP slide. The VBA editor just doesn't list any proerties like
it.

This and other clunkiness makes me want to rebuild the program as a
stand-alone VB application. (Getting access to certain dialog boxes
is another reason).

This would solve all my problems except that I need the detail of the
PP slide-- namely the AutoShapes-generated diagram of the well. I
know I can save the slide as an image (.gif, jpeg) and then use a
picturebox to display that image in my VB program, but it never looks
as good as the original. (The diagram utilizes lots of textures and
shading.) It becomes even more fuzzy upon printing the form, which is
something this new VB app will need to do.

I know VB offers the shape control, but the limited fill styles don't
suit my needs.

So.... is there any way to get that AutoShape object that exists in
PowerPoint, Word, etc, onto a pure VB form? Some component or
reference I can add?

Thanks,

--E Harris