Using a picture on a form requires the pictures to be "loaded" into the form. You cannot "load" a picture from the worksheet into a userform. The worksheet picture has to be "exported" to the hard drive first then "loaded" into the form. The following utilities use Pictures, in one way or another...
Random Picture Splash Screen:
When the workbook is opened, the splash screen appears. Depending on the quantity of pictures available, each time you open this workbook, a possible different picture will appear. To Close the splash screen the user only has to click the image display. It is not a Timed splash screen. You can view the next picture by clicking the "Next Picture" button. There must be pictures in the same folder as the utility. The image resizes to the picture size but if the picture is larger than the preset image holder then the size of the image holder will be the maximum size. Large pictures may be slightly distorted as the aspect ratio is not held. If the folder is void of JPGs or GIFs then a Msgbox Alert will show but the display form will still appear...
RandomPix.xls allows both GIF and JPG pictures.
RandomPix.xls
TextPic_Maker_Pro:
The macro is attached to a toolbar button which will automatically appear when you open this workbook. You name an area on the worksheet as "BigArea". Use the Name Box (Press Enter Key). The area selected can be one cell or many. The more cells selected, the bigger the result. The Text area selected and named "BigArea" will be saved as a GIF in the current folder as this workbook. The name of the GIF will be the current time and date the gif was created:
Time_15_49_24_Date_17_Mar_2006.gif
PicExporter:
Exports a single picture on the worksheet to the current folder and saved as a GIF in the current folder as this workbook. The name of the GIF will be the current time and date the gif was created:
Time_18_49_24_Date_18_Mar_2006.gif