create a diagram in vba

create a diagram in vba

Anonymous
Not applicable
297 Views
2 Replies
Message 1 of 3

create a diagram in vba

Anonymous
Not applicable
What is the best way to create a diagram to use in my VBA form. I need the
user to view the diagram behind all the buttons and textboxes as associated
with what the check box actually does. I'm drawing the image in Autocad and
taking a screenshot to Bitmap right now but the image is lacking in quality.
0 Likes
298 Views
2 Replies
Replies (2)
Message 2 of 3

Anonymous
Not applicable
As far as creating a diagram, the options are almost endless. Any number of
paint programs, or photo manipulation programs are available.. Paint Shop
Pro is inexpensive and very powerful, theres always Adobe Photoshop. A
simpler one is LView Pro.

As far as the screen shot, if its a full screen shot of your diagram, it
will probably need to be scaled down to fit on the form, right? well this
could produce some pixelation when the size reduces, thereby causing the
quality to suffer, as well as having a picture that is hogging all sorts of
memeory when its not necessary to do so.

You are talking about using the PICTURE property of your form right? This
will put any picture (bmp, jpg, etc..) as the background of the form. Then
you can over lay controls on top of that..

If you take the screen shot, try zooming out on it first, so it is smaller.
Try to get it to the actual size of the form you are making it for, then
take the screen shot. Open the screen shot in any paint program, (even
windows paintbrush will do), and crop the image around the part you want to
keep. Put this smaller image in the background of your form, and DONT SCALE
IT (or size to fit)..! It will not lose quality this way.

If its an issue of diagram complexity, then perhaps a paint program such as
Paint Shop Pro would be inorder because of its picture capabilites, drop
shadow, opacity, etc.. etc.. It would add finess to the diagram.

Hope this helps.
-ANdrew

"Ron Heigh" wrote in message
news:7C390A9201DB1EDDEF35639E4703ACA2@in.WebX.maYIadrTaRb...
> What is the best way to create a diagram to use in my VBA form. I need
the
> user to view the diagram behind all the buttons and textboxes as
associated
> with what the check box actually does. I'm drawing the image in Autocad
and
> taking a screenshot to Bitmap right now but the image is lacking in
quality.
>
>
0 Likes
Message 3 of 3

Anonymous
Not applicable
Thankyou Andrew.

I'll try a paint program and see if it is any better.


"Andrew Allen" wrote in message
news:9F99C63FB49B3AD1CACE4C8522743B92@in.WebX.maYIadrTaRb...
> As far as creating a diagram, the options are almost endless. Any number
of
> paint programs, or photo manipulation programs are available.. Paint Shop
> Pro is inexpensive and very powerful, theres always Adobe Photoshop. A
> simpler one is LView Pro.
>
> As far as the screen shot, if its a full screen shot of your diagram, it
> will probably need to be scaled down to fit on the form, right? well this
> could produce some pixelation when the size reduces, thereby causing the
> quality to suffer, as well as having a picture that is hogging all sorts
of
> memeory when its not necessary to do so.
>
> You are talking about using the PICTURE property of your form right? This
> will put any picture (bmp, jpg, etc..) as the background of the form.
Then
> you can over lay controls on top of that..
>
> If you take the screen shot, try zooming out on it first, so it is
smaller.
> Try to get it to the actual size of the form you are making it for, then
> take the screen shot. Open the screen shot in any paint program, (even
> windows paintbrush will do), and crop the image around the part you want
to
> keep. Put this smaller image in the background of your form, and DONT
SCALE
> IT (or size to fit)..! It will not lose quality this way.
>
> If its an issue of diagram complexity, then perhaps a paint program such
as
> Paint Shop Pro would be inorder because of its picture capabilites, drop
> shadow, opacity, etc.. etc.. It would add finess to the diagram.
>
> Hope this helps.
> -ANdrew
>
> "Ron Heigh" wrote in message
> news:7C390A9201DB1EDDEF35639E4703ACA2@in.WebX.maYIadrTaRb...
> > What is the best way to create a diagram to use in my VBA form. I need
> the
> > user to view the diagram behind all the buttons and textboxes as
> associated
> > with what the check box actually does. I'm drawing the image in Autocad
> and
> > taking a screenshot to Bitmap right now but the image is lacking in
> quality.
> >
> >
>
>
0 Likes