How Draw a picture using VBA in Excel?

  • Thread starter Thread starter Baju Antony
  • Start date Start date
B

Baju Antony

Hello,

Can anyone suggest a method to draw a picture in EXCEL using the VBA.
The picture to be drawn uses some bitmaps and super-imposed by texts
from the excel sheet. The text drawn as picture should match with the
same format as in excel (like font, bold,etc.,)


Thanks in advance
Baju Antony
 
Since Excel doesn't let you copy, and then paste special-as a picture, like
you can in Word, I'm thinking you might be able to use the CAMERA tool? Try
this: Copy some cells. Then, holding the shift key, hit the Edit menu. You
have an extra option to "paste picture". But it's not a bmp or anything...
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
 
Would anything like this work?

Sub Demo()
Range("A1:C10").CopyPicture _
Appearance:=xlScreen, _
Format:=xlPicture
Range("E1").Select
ActiveSheet.Pictures.Paste
End Sub

Probably won't help, but hopefully may give you something to work with.
Dana DeLouis
 
Just a note that if you select your range and click on ShiftEdit, you'll get a
"Copy Picture" option that you don't normally get.

In fact, you can shiftEdit and paste Picture link, too.

Dana's code look suspiciously like he recorded a macro when he did it manually.

You could try the same thing if you want to see all the options.
 
Hello All,

Thanks for your response. But I think I have not put the question
properly. I will reframe my question.

The excel sheet has different columns of text data. Each column of the
texts has been formated differently (like font, size,etc). I have to
create a picture on EXCEL sheet using one or more texts.

Some pictures requires a background of another bitmap file(located on
the harddisk).

Hope this is clear

Best regards
Baju Antony
 
Back
Top