| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select pictures from a sheet into an other sheet
I just have p.a. 5 pictures in sheet 3 as a master.
In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select pictures from a sheet into an other sheet
Not using a formula.
But you could use a macro. JE McGimpsey shares how to do it with pictures: http://www.mcgimpsey.com/excel/lookuppics.html Pjotr70 wrote: I just have p.a. 5 pictures in sheet 3 as a master. In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select pictures from a sheet into an other sheet
Hello Dave, Thanks for your hind, I tried it at home but failed. Where do I
place the pictures? I tried to understand the example they give on there site but couldntr changed it with my own pictures Can you help me? Kind regards Pieter "Dave Peterson" wrote: Not using a formula. But you could use a macro. JE McGimpsey shares how to do it with pictures: http://www.mcgimpsey.com/excel/lookuppics.html Pjotr70 wrote: I just have p.a. 5 pictures in sheet 3 as a master. In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select pictures from a sheet into an other sheet
You could put the pictures where they belong. JE's code toggles the visibility
of the pictures--not the locations. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Pjotr70 wrote: Hello Dave, Thanks for your hind, I tried it at home but failed. Where do I place the pictures? I tried to understand the example they give on there site but couldntr changed it with my own pictures Can you help me? Kind regards Pieter "Dave Peterson" wrote: Not using a formula. But you could use a macro. JE McGimpsey shares how to do it with pictures: http://www.mcgimpsey.com/excel/lookuppics.html Pjotr70 wrote: I just have p.a. 5 pictures in sheet 3 as a master. In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select pictures from a sheet into an other sheet
Hello Dave,
Finally it works!! The JE's code must be placed in the background frm the sheet you worked with. Thanks again ! "Dave Peterson" wrote: You could put the pictures where they belong. JE's code toggles the visibility of the pictures--not the locations. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Pjotr70 wrote: Hello Dave, Thanks for your hind, I tried it at home but failed. Where do I place the pictures? I tried to understand the example they give on there site but couldntr changed it with my own pictures Can you help me? Kind regards Pieter "Dave Peterson" wrote: Not using a formula. But you could use a macro. JE McGimpsey shares how to do it with pictures: http://www.mcgimpsey.com/excel/lookuppics.html Pjotr70 wrote: I just have p.a. 5 pictures in sheet 3 as a master. In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select pictures from a sheet into an other sheet
The worksheet_calculate event fires when the worksheet that owns the code is
recalculated. So it has to be there. Glad you found the solution. Pjotr70 wrote: Hello Dave, Finally it works!! The JE's code must be placed in the background frm the sheet you worked with. Thanks again ! "Dave Peterson" wrote: You could put the pictures where they belong. JE's code toggles the visibility of the pictures--not the locations. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Pjotr70 wrote: Hello Dave, Thanks for your hind, I tried it at home but failed. Where do I place the pictures? I tried to understand the example they give on there site but couldntr changed it with my own pictures Can you help me? Kind regards Pieter "Dave Peterson" wrote: Not using a formula. But you could use a macro. JE McGimpsey shares how to do it with pictures: http://www.mcgimpsey.com/excel/lookuppics.html Pjotr70 wrote: I just have p.a. 5 pictures in sheet 3 as a master. In sheet 1 I like to show just 1 of the 5 pictures on sheet 1 on a special place depending on a value in cell A1. With figures it is possible with vloopup/hlookup but how to magae with pictures? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate Row Select in Sheet 1 then Paste to Sheet 2 | Excel Worksheet Functions | |||
| Define sheet name then select sheet | Excel Discussion (Misc queries) | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
Linear Mode
