Solved

Is it possible to create a Scrolling Marquee on a Outlook Visual Basic Form?

Posted on 2004-08-08
4
500 Views
Last Modified: 2013-11-25
Can someone explain to me if it is possible to create a Scrolling Marque across an Outlook Form?  If so, in the simpliest of simple instructions could you walk me through it.  

Thanks,

itsmevic
0
Comment
Question by:itsmevic
  • 2
4 Comments
 
LVL 17

Expert Comment

by:cem_turk
ID: 11746347
i dont know much about outlook forms but in VB you can create a scrolling marquee with a label and a timer control.

by the help of the timer control you can change the position of the label continously. you should change the timers interval to determine the speed.
and you should use a code like this ;
private sub mytimer()
mylabel.left= mylabel.left -5
end sub

with this code your marquee will dissappear from the left :)
you should add some if statments to do what you want
0
 
LVL 4

Accepted Solution

by:
cachedVB earned 500 total points
ID: 11746370
private sub mytimer_timer()
mylabel.left= mylabel.left -5
if mylabel.left <= (0 - mylabel.width) then
mylabel.left = myform.width & mylabel.width
end if
end sub
0
 
LVL 4

Expert Comment

by:cachedVB
ID: 11746373
oops! its myform.width + mylabel.width
0
 

Author Comment

by:itsmevic
ID: 11748867
Is there anyway you could walk me through adding this into Outlook forms correctly.

I've went in created my label, right clicked and chose Properties, then go to, then I click on the Values tab, then I click on the New button.  I give me field a Name then set the Type as "Formula" Click on the Edit button and the Formula Window appears.  I paste the code suggested above in this Formula Window:  

 private sub mytimer_timer()
mylabel.left= mylabel.left -5
if mylabel.left <= (0 - mylabel.width) then
mylabel.left = myform.width + mylabel.width
end if
end sub

When I click oK it keeps telling me "Unknown Field"

Your help is greatly appreciated.  Thanks - itsmevic
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sending a email via excel using vba 6 82
What the difference between blend and Visual Studio 3 100
Where did System.Data.Objects go? 2 28
PL SQL Developer 7 36
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question