| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro to Save Copy of File to New Location | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
