View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Syed Zeeshan Haider[_7_] Syed Zeeshan Haider[_7_] is offline
external usenet poster
 
Posts: 16
Default Show method stops macro

Hello Experts,
I have Excel 97 Pro on Win98SE.

I have a certain piece of code in which UserForm1.Show stops the macro?
E.g.

Public Sub SomeProcedure()

' some working code here

UserForm1.Show ' After this line, the macro won't proceed

' some should-work code here

End Sub

Why does UserForm1.Show stop the macro?
Is there any way to prevent it?

Thank you,
--
Syed Zeeshan Haider



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com