<div>
Thank you Mike ..This does resolve the issue , however the message only displays only one word at a time , so I tried to merge the cells and &nbsp;amend the code &nbsp;slightly ... Set tcell= Range ( &quot;A10:D10&quot;) &nbsp;so that I can see the entire message all at once and then it keeps scrolling throughout , for example I want it to display in cell D2:I2 .. Any insight would be appreciated
</div>

<div>
Tested this. I would just make the width wider 

<pre><code class="code-10 nolinks" id="code-20-42438654-1">Sub DoMarquee()
 Dim sMarquee As String
 Dim iWidth As Integer
 Dim iPosition As Integer
 Dim rCell As Range
 Dim iCurPos As Integer

 'Set the message to be displayed in this cell
 sMarquee = &quot;This is a scrolling Marquee.&quot;

 'Set the cell width (how many characters you want displayed at once
 iWidth = 10

 'Which cell are we doing this in?
 Set rCell = Sheet1.Range(&quot;M2&quot;)

 'determine where we are now with the message.
 ' instr will return the position of the first
 ' character where the current cell value is in
 ' the marquee message
 iCurPos = InStr(1, sMarquee, rCell.Value)

 'If we are position 0, then there is no message, so start over
 ' otherwise, bump the message to the next characterusing mid
 If iCurPos = 0 Then
 'Start it over
 rCell.Value = Mid(sMarquee, 1, iWidth)
 Else
 'bump it
 rCell.Value = Mid(sMarquee, iCurPos + 1, iWidth)
 End If

 'Set excel up to run this thing again in a second or two or whatever
 Application.OnTime Now + TimeValue(&quot;00:00:01&quot;), &quot;DoMarquee&quot;
End Sub
</code></pre>
<a href="https://stackoverflow.com/questions/29394524/make-a-cell-scroll-marquee-text-right-to-left" rel="ugc">https://stackoverflow.com/questions/29394524/make-a-cell-scroll-marquee-text-right-to-left</a>
</div>

<div>
My code won't work with merged cells. If you want it to be wider then you will have to widen the cell. 
 
I haven't tested @Shaun's VBA, but it looks like it might work with the merged cells better than mine will.
</div>

<div>
Hey Shaun Unfortunately i t does not work , I changed the width and when I run the code I get a message stating &nbsp;, The macro may not be available in this workbook or all macros may be disabled ... I checked Trust centre &gt;&nbsp;Trust Centre seetings &gt;&nbsp;Macro setings and it looks fine to me .. Not sure why I am still getting the error message.
</div>

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned. 
 
I have recommended this question be closed as follows: 
 
Accept: Mike in IT (<a href="https:#a42438063" rel="ugc">https:#a42438063</a>) 
 
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above. 
 
broomee9 
Experts-Exchange Cleanup Volunteer
</div>

<div>
<div class="content wysiwyg-content">
There is a message &quot;&nbsp;Due to high inflow of call talk times were impacted &quot;&nbsp;.... As soon anyone opens my excel attachment I want this message to scroll from left to right and keep scrolling on the screen
</div>
</div>

There is a message " Due to high inflow of call talk times were impacted " .... As soon anyone opens my excel attachment I want this message to scroll from left to right and keep scrolling on the screen

I want to scroll a message on Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.