Form with a text label like a "banner"

[noliveira]

Dear all,
The idea is to make appear in lblBannerMessage all information that exist in cells.

For example:
First message: Sales: 1.000,00€
Second message: Cost: 500,00€
And so one…

The message should appears moving always from right to left.
This is possible?
Thanks in advance and best regards,

[davesexcel]

Dear all,
The idea is to make appear in lblBannerMessage all information that exist in cells.

For example:
First message: Sales: 1.000,00€
Second message: Cost: 500,00€
And so one…

The message should appears moving always from right to left.
This is possible?
Thanks in advance and best regards,

Hi,
You may need a label for each Item:
then when you initialize the userform you could have a code like this

Private Sub UserForm_Initialize()
Label1.Caption = "Sales: " & Format(Range("C1"), "#,##0.00 ""€""")
Label2.Caption = "Cost: " & Format(Range("C2"), "#,##0.00 ""€""")

End Sub

[noliveira]

Hi davesexcel,
Thanks for your answer...

I was trying to make waht I need and I thing that have found a way... Now my problem is to know how to make a loop and start from the beginner.
Please see attached file...
Regards,

[royUK]

noliveira

This is a duplicate post of your question here:

http://www.excelforum.com/showthread.php?t=633969

have you bothered to read the Forum Rules? You should only ask the question once,

[noliveira]

Sorry royUK,
I forgot that I have posted in the past this topic...

Thanks a lot for the example given! It´s exactly what I need...
Regards,