S
Strugling
I need to get a pop up window, with message and pictures, to open when I open
an excel sheet.
p.s. not advanced user.
an excel sheet.
p.s. not advanced user.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
One does not "Open" a sheet. One selects or activates a sheet within a
workbook.
Do you mean open a workbook?
This would require VBA event code which fires when the workbook is opened.
If you did mean "sheet" then sheet_activate event code could be used.
What type of pictures and where would they be placed?
Would the pictures be embedded in the workbook?
Perhaps explain a bit more about what effect you wish to achieve.
What you ask is doable.
Gord Dibben MS Excel MVP
workbook.
Do you mean open a workbook?
This would require VBA event code which fires when the workbook is opened.
If you did mean "sheet" then sheet_activate event code could be used.
What type of pictures and where would they be placed?
Would the pictures be embedded in the workbook?
Perhaps explain a bit more about what effect you wish to achieve.
What you ask is doable.
Gord Dibben MS Excel MVP
S
Strugling
Pop window fires when I open an excel workbook. That was what I meant.
Adding to that, I want to enclode some pictures within that pop up little
window, these pictures are stored on my desktop.
Finally, can I edit the duration of time this little window pops up for.
i.e. 5/6 seconds before it closes itself.
Thanks for giving me the hope by saying doable.
Adding to that, I want to enclode some pictures within that pop up little
window, these pictures are stored on my desktop.
Finally, can I edit the duration of time this little window pops up for.
i.e. 5/6 seconds before it closes itself.
Thanks for giving me the hope by saying doable.
G
Gord Dibben
You can create a userform and add pictures to the userform.
*.bmp or *.jpg seem to work OK
NOTE: these will be embedded in the workbook with the userform so make them
email size like 420 x 320 or around 50kb
When workbook opens, the userform is loaded on screen.
OnTime code to set a duration of 6 seconds then userform closes.
All this is done through VBA.
Open a new workbook.
Alt + F11 to open Visual Basic Editor.
Insert>Userform and go from there.
Size to your needs.
From Control Toolbox select "Image"
Draw a box for your image size. Right-click and
Properties>Picture........browse to first picture and Open or double-click.
Now you have a picture on your userform.
Add more........save workbook regularly.
See VBA help for loading and unloading a userform.
Also see help for OnTime method for setting duration.
If you get stuck with any of this, email me at gorddibbATshawDOTca
I might get time to build you an example workbook.
Gord
*.bmp or *.jpg seem to work OK
NOTE: these will be embedded in the workbook with the userform so make them
email size like 420 x 320 or around 50kb
When workbook opens, the userform is loaded on screen.
OnTime code to set a duration of 6 seconds then userform closes.
All this is done through VBA.
Open a new workbook.
Alt + F11 to open Visual Basic Editor.
Insert>Userform and go from there.
Size to your needs.
From Control Toolbox select "Image"
Draw a box for your image size. Right-click and
Properties>Picture........browse to first picture and Open or double-click.
Now you have a picture on your userform.
Add more........save workbook regularly.
See VBA help for loading and unloading a userform.
Also see help for OnTime method for setting duration.
If you get stuck with any of this, email me at gorddibbATshawDOTca
I might get time to build you an example workbook.
Gord