View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBAQuest VBAQuest is offline
external usenet poster
 
Posts: 4
Default Question on automating Dialogboxes in VBA

Hello, I was wondering if the following is possible in VBA. I am
running a model that pops a dialog box up once in a while - each time,
the button I click to rerun the model is exactly the same, i.e. 'Run'.
Is there anyway I can automate this process, so everytime the dialog
box pops up, it automatically clicks the 'Run' button. If not VBA, what
other program would be useful here. I was wondering if the answer might
be as simple as being able to run a Newline function within a dialog
box. Thanks.