Hi there folks!!
Is it possible to use the marquee scrolling text affect in a cell in excel?
I want to try and make my sheet a bit slicker and this would look great.
Thanks for reading and for any advice
Hi there folks!!
Is it possible to use the marquee scrolling text affect in a cell in excel?
I want to try and make my sheet a bit slicker and this would look great.
Thanks for reading and for any advice
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
I have seen it in userforms and xml excel but not a standard worksheet.
I have no idea were you would even begin to write/find the code for it though.
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
THere was this post a while back but i don;t have internet access to view it!!
It was posted by CarimHi,
I remember Andy Pope did a replication of a marquee, in a worksheet called pixilate.xls
http://www.andypope.info/index.htm
that was quick, try:
http://www.mrexcel.com/archive2/47900/55648.htm
I am unable to access that page you wouldn't screen dump it for me would you?
heres the code discussed in the post
Let's suppose the Form is UserForm1.
Add the following Controls:
Frame1 to serve as a container for the Label .
Label1 to display the scrolling Text. This label should be placed within Frame1.Adjust its position as required.
SpinButton1 to change the Speed of the srolling text.
One CommandButton:ScrlBttn to activate the scrolling.
One CommandButton : StpScrlButtn to halt the Scrolling.
One CommandButton : UnloadFrmBttn to unload the Form.
Note that ,unlike the other controls, the 3 CommandButtons have their names changed for clarity purposes. Rename them via the Property sheet in the VBE at design time.
Ok, that's all for the UserForm design.
Now, let's begin with the Codes and Modules.
Paste this Code in the UserForm1 Module:
orPlease Login or Register to view this content.
Please Login or Register to view this content.
good luck
Thanks for that i'll give it a try and get back to you, probs 2moro though!!
I coundt find the one on andy popes site, but this defintly sounds intresting.
Let you know if i find anything new.
heres an intresting peice of code form Ivan F Moala of the excel files.
just put in a blank workbook and run the macro. Its probably about the best you can get in just plain old excel.
for any one else with internet access heres a link to the postPlease Login or Register to view this content.
http://www.mrexcel.com/archive2/8500/9465.htm
Andy hasn't put it on his site, but here's a copy that he gave me.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
How the hell do i put a web browser on an excel sheet guys?
Hi guys i still don't know how to put a web browswer into an excel spreadsheet and ill be your slave in the afterlife if someone tells me how?
cheers everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks