Scrolling Text

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

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.

THere was this post a while back but i don;t have internet access to view it!!

Hi,

I remember Andy Pope did a replication of a marquee, in a worksheet called pixilate.xls

http://www.andypope.info/index.htm

It was posted by Carim

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:

Please Login or Register  to view this content.

or

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.

Please Login or Register  to view this content.

for any one else with internet access heres a link to the post

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.

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