Posts by jonmelmo

I have this code that checks to make sure the workbook is not open/in use.

How would I modify it to try again in 5 seconds and after 3 tries then send the MsgBox?

 If wBook.ReadOnly = True Then        MsgBox "Database is in use. Please try after sometimes.", vbookonly + vbCritical, "error"           
     Exit Sub   
 End If

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

mrexcel.com/board/threads/dual…-then-main-excel.1209303/

When searching I keep finding this code or examples that centers the userForm on the excel window that is open. I want to keep the excel window on 1 screen and have it open the userform on the other monitor of a duel monitor set up. Does any one have suggestions?