Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to picture stored in workbook
I want to be able to change the Picture property of an Image control
using VBA. The images need to be stored 'in' the workbook, not an external folder. In pseudo-code, I need something like: Sub() If x = y then Me.Image1.Picture = ActiveSheet.Shapes("Image1").Picture Else: Me.Image1.Picture = ActiveSheet.Shapes("Image2").Picture End If End Sub It is very important that I DON'T have to specify a full filepath using LoadPicture(), as the workbook will be used on different machines without access to the image folders. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink stored in an external workbook | Excel Discussion (Misc queries) | |||
how do I refer a cell to workbook name not worksheet | Excel Discussion (Misc queries) | |||
Refer to more than one worksheet in a workbook | Excel Worksheet Functions | |||
how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
refer to dynamic range in closed workbook with ADO | Excel Programming |