[HELP] Creating pop-up windows and pulling data from Excel in .PPS
uran...@yahoo.com.singapore
As I am totally hopeless when it comes to programming, so I would
appreciate if anyone can help me out.
I want to make a presentation slide show that is somewhat "
interactive". Let's suppose I have one slide with three objects: a
star, a circle, and a rectangle.
I want to have it that later in the slide show, if I click on the star
object, then a pop up appears with a text saying "Star is available in
three colors: StarGreen, StarRed, and StarWhite"
Similarly, it should happens if I clicked the circle and rectangle
objects.
The text "Star is available in three colors: StarGreen, StarRed, and
StarWhite" should comes from a cell or an array of cells in an Excel
worksheet. The reason is that there will be many objects in the slides
and the content can be edited easily.
When I click the pop-up windows the second time, it should be
dissapear.
Furthermore, it would be great if the word StarGreen, StarRed, and
StarWhite is actually a hyperlink that if it gets clicked, it would
open another pop-up windows with a more detailed information pulled
from Excel (perhaps it is the same Excel file, but different
worksheets).
I have been looking into this website:
- http://www.pptfaq.com/FAQ00891.htm for retrieving info from Excel
sheet
- http://www.pptfaq.com/FAQ00691.htm for creating popup text with VBA
so I guess my scenario is seems to be do-able. Unfortunately, because
I don't have programming skill I am unable to make the above sample
codes to work.
I am also not sure if these kind of data-linking will work if it is
delivered in .PPS/.EXE format and the user does not have Microsoft
Excel 2003 installed.
Could anyone help me with a working VBA script for such a scneario?
-Deka