Normally a macro will stop waiting for a users input but you can forc
the macro to continue.


To allow the macro to continue after the Dialog box has been displaye
on the Form module page you will need to add a sub routine

Private Sub UserForm_Activate()

Place code here that or call another sub rotine from here

End Su

--
Message posted from http://www.ExcelForum.com