Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb help
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. -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=532033 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|