While userform open do events timely basis

[CsJHUN]

Hi boardlies

I will have 2 excel file, 1-1 sheet in each, both will have open userform.
Lets say "A" is for data registering, and "B" is for showing that data. I would like to import data to "B" for each minutes.
"A" use userform to input data to "A" excel, what should be visualised on "B" excel and userform.

This is how i started:
Like said above: "A" use userform buttons, to register data with timestamp to "A" excel file, and save the file each time the user input data.
where i stuck: How can "B" read the "A" file once in every minutes while userform in "B" open (than do some other stuffs, but that shouldn't be problem)
Thanks in advance
J

 

[CsJHUN]

Figured out:

Private Sub UserForm_Initialize()
lbl_time.Caption = Format(Now, "yyyy-mm-dd hh:nn:ss") 'just for checking and showing its updated
re_read_db:
    time_gap= #12:01:00 AM#
    a = Now
    Do
    b = Now
    DoEvents
    Loop Until b >= a + time_gap
'here i put other privatre subs what sould be done
GoTo re_read_db
End Sub

the userform querry close will unload the userform, so this should be killed