LinkBack URL
About LinkBacks
Does anyone know how to make an object, e.g. Oval Object to flash a solid yellow & white colour? It's bugging the hell out of me. I can make blinking cells, but not objects...HELP!!!
Does anyone know how to make an object, e.g. Oval Object to flash a solid yellow & white colour? It's bugging the hell out of me. I can make blinking cells, but not objects...HELP!!!
Why would you want to ?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Well, I'm a merchant seaman and want to study lights and shapes, the ships signal. I require a flashing yellow light...the light a hover craft uses.
I think it would be cool too finish it and then share it with the shipping community so they can help them study.
Try this modified version of Chip's blinking text example.
http://www.cpearson.com/excel/BlinkingText.aspx
Thanks Andy
Many thanks...now to work on project!
Can I have 2, 3 or 4, etc blinking objects on 1 sheet?
Yes just add additional code to reference those objects.
For all objects to blink at the same rate just use the single stop/start blinking routines.
If you want shapes to blink at different rates then you will need separate stop/start routines calling separate routines to update specific shapes.
Not that too many different rates of blinking will more than likely cause a problem as you are unable to use excel whilst the code is running.
You maybe better of using an animated gif which would not require coding.
Well, I planned using animated gifs however they don't animate? What am I doing wrong?
just inserting the gif will not allow the animation to play.
You need to use this approach
http://www.excelforum.com/excel-gene...-in-excel.html
I must be a real idiot, as I have seen that post but make no sense on the VBA code. i.e. don't work.
Dose it mean that I cannot see the animated gif unless the sreadsheet is viewed in a web browser?
Sub Animate()
'Private Sub WebBrowser1_StatusTextChange(ByVal Text As String)
With Me.WebBrowser1
.Navigate "\\...\my pictures\spidey.gif"
End With
End Sub
No, you need to insert a web browser control to the worksheet.
In the Control Toolbox toolbar is a button called More Controls. Use this to select the web browser control and add it to the worksheet.
Hi Andy
Thanks...it seems to be a real "run round". Today's day and age, everything is paperless. Funny Uncle Billis making is a pain in the...... to add a simple gif file.
Actually I'm glad. Can you image the horrific spreadsheets you would get if it were too easy to make things flash.
Perhaps a spreadsheet is not the best application to use.
how to make an image or picture auto blinking using macro in excel when workbook open.
please help
thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks