At the onset, I am not proficient with VBA coding and trying my hands on it for the first time.
I created a message board in the excel tool that I am building that displayes three messages. It is a List box for which the Captin keeps changing every 5 seconds.
This is (I believe) preventing the excel file from closing. When I close, I get the Save / Dont save option. Irrespective of what I press, the file closes and then opens up again.
When I turn both of these codes off, it closes properly.
I am giving the code below:
Under Module 1:
Under 'This Workbook' :![]()
Public Sub Scroll() Dim temp As Variant temp = Sheet20.Label1.Caption Sheet20.Label1.Caption = Sheet20.Label2.Caption Sheet20.Label2.Caption = Sheet20.Label3.Caption Sheet20.Label3.Caption = temp Application.OnTime Now + TimeValue("00:00:05"), "ScrollIt" End Sub
![]()
Public Sub Workbook_Open() Application.OnTime Now + TimeValue("00:00:05"), "Scroll" End Sub











LinkBack URL
About LinkBacks

Register To Reply

Bookmarks