K
kckar
i have to do the following, can anyone help me?
Import both an image and a wave file of your own choosing into Excel.
Create a macro that activates that wave clip and then uses the “time”
functions in Excel to make an image slowly “fade away” [over say a 15
second period] and then slowly reappear [again over a 15 second
period].
Hint on making an image appear to fade away: Several approaches, but
one it to increase the amount of “lighting” provided to an image (this
is one of the options on the picture tool bar).
Hint on “time” functions: For the “time” functions, use which ever you
think are appropriate, I’d actually like to see you guys do a little
snooping around for these; see the functions under the category “Data &
Time”). You may find for example the NOW() function to be useful {as
well as the HOUR, MINUTE and SECOND calculations: Use Excel’s function
help to learn how these may help}. Example of how you might set things
up on a spreadsheet:
The one thing to note here however is that the NOW() function will only
update “if you ask it to” (eg. by hitting F9 or making some other change
in the spreadsheet – in this way they act a little like the RAND()
function). In the VB editor you can also do this using the one-line
command “Calculate”. Any time that is used, the workbook is updated.
Import both an image and a wave file of your own choosing into Excel.
Create a macro that activates that wave clip and then uses the “time”
functions in Excel to make an image slowly “fade away” [over say a 15
second period] and then slowly reappear [again over a 15 second
period].
Hint on making an image appear to fade away: Several approaches, but
one it to increase the amount of “lighting” provided to an image (this
is one of the options on the picture tool bar).
Hint on “time” functions: For the “time” functions, use which ever you
think are appropriate, I’d actually like to see you guys do a little
snooping around for these; see the functions under the category “Data &
Time”). You may find for example the NOW() function to be useful {as
well as the HOUR, MINUTE and SECOND calculations: Use Excel’s function
help to learn how these may help}. Example of how you might set things
up on a spreadsheet:
The one thing to note here however is that the NOW() function will only
update “if you ask it to” (eg. by hitting F9 or making some other change
in the spreadsheet – in this way they act a little like the RAND()
function). In the VB editor you can also do this using the one-line
command “Calculate”. Any time that is used, the workbook is updated.