View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default why the method "show" invalid?

It should be DialogSheets, not Dialogs:
Application.DialogSheets("Dialog1").Show

You have:
<Application.dialogs("入库对话框").show


Regards,
Greg

"kirsten" wrote:

Than you for your prompt answer
when i run code "Application.dialogs("入库对话框").show" , window tell error code
13, type not match
when i try code "thisworbook.sheets("入库对话框").activat e", it doesnot execute
the dialog
what can i do next?


"kirsten" wrote:

I am trying to let the dialoguesheet "入库对话框" show while i initialize my VBA
Micro,the vba code is as follow:
thisworkbook.sheets("入库对话框").show
when i run the code, the window tell me error code '1004' and class
dialoguesheets's show method invalid.
could anyone help me with the problem? thanks