Draw a Picture in MSExcel using VBA?

[Baju Antony]

Hello,

My excel sheet contains 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 combination of one or more texts
by click of a button.

In addition some pictures while creation uses a background from bitmap
file(located on the harddisk).

Can anyone suggest any method.

Best Regards
Baju Antony

 

[Debra Dalgleish]

Turn on the macro recorder (Tools>Macro>Record New Macro)
Record the steps as you apply formatting to the cells
Add a background picture
Turn off the recorder.

The recorded code should give you a good start.