Userforms have 6 properties that relate directly to ScrollBars. Set the .ScrollBars property to 2 Now, set the .ScrollTop to 0 (So it will appear always at the top of the form)
and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try setting this property to 200 and see how that works. There's a more "elegant" way of finding this number, but, this works as well. On Mon, Sep 5, 2011 at 7:29 AM, Bheema Shankar <shankar.n...@gmail.com>wrote: > hai to all, > > I need to scroll and blink label caption on the userform. I am using > Excel 2003. Pls guide me how to do this ? > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ......................... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
