How can you assign a bmp. file to a formula or macro?
 

I have a spreadsheet that is for different certifications. I need to be able
to have different .bmp files assigned to a particular cell. I would like to
be able to have a formula or macro that would insert the files. Is that
possible?

Thanks
Kelly

How can you assign a bmp. file to a formula or macro?
 

Here is a macro for inserting a single pictu

Sub Macro2()
Range("F23").Select
ActiveSheet.Pictures.Insert ("C:\WINNT\Coffee Bean.bmp")
End Sub

Adapt it or use a loop to insert a set of pictures.
--
Gary's Student


"Kelly" wrote:

I have a spreadsheet that is for different certifications. I need to be able
to have different .bmp files assigned to a particular cell. I would like to
be able to have a formula or macro that would insert the files. Is that
possible?

Thanks
Kelly

How can you assign a bmp. file to a formula or macro?
 

Thanks for you help, I'll give this a try and let you know...

"Gary''s Student" wrote:

Here is a macro for inserting a single pictu

Sub Macro2()
Range("F23").Select
ActiveSheet.Pictures.Insert ("C:\WINNT\Coffee Bean.bmp")
End Sub

Adapt it or use a loop to insert a set of pictures.
--
Gary's Student


"Kelly" wrote:

I have a spreadsheet that is for different certifications. I need to be able
to have different .bmp files assigned to a particular cell. I would like to
be able to have a formula or macro that would insert the files. Is that
possible?

Thanks
Kelly

How can you assign a bmp. file to a formula or macro?
 

Kelly

See JE McGimpsey's site for adding pictures based on cell value.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP

On Thu, 11 Jan 2007 05:28:00 -0800, Kelly
wrote:

I have a spreadsheet that is for different certifications. I need to be able
to have different .bmp files assigned to a particular cell. I would like to
be able to have a formula or macro that would insert the files. Is that
possible?

Thanks
Kelly