View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SJW_OST[_2_] SJW_OST[_2_] is offline
external usenet poster
 
Posts: 39
Default User created Dialog Box

I am using this code to open my own dialog box created by right clicking on
"Sheet1", choosing Insert and selecting "MS Excel 5.0 Dialog".

Sub Dialog()
DialogSheets("Dialog1").Show
End Sub

When this code is ran, the code will not goto "End Sub" until the dialog box
closes.
Will code run if a dialog box is open? Can I use code to close the dialog box?
Any help is greatly appreciated.