View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Show method stops macro

Hi
glad you found your error (and just to confirm: your time looks o.k.
now) :-)


--
Regards
Frank Kabel
Frankfurt, Germany

"Syed Zeeshan Haider" schrieb im Newsbeitrag
...
"Frank Kabel" wrote in message

...

to be honest I think the problem is on your side (something in your
time settings). Your post is 11 hours ahead. So somehow your
newsreader/etc is not set-up correctly


You are right.
Some kid had changed the time zone of my PC to that of Canada. That

was
causing the problem. I checked it right after Bob told that he also

was
facing this problem with my posts.

On a sidenote: IMHO I think it was correct from Don to post this to

the
NG :-)


Actually, I had assumed that only Don was facing that problem. I have
received many off-topic political responses on other NG's of VB

that's why I
feel bad Abu dumping an excellent technical NG with political crap

like some
amateur politicians do.

Thanks, Frank!
--
Syed Zeeshan Haider



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

"Syed Zeeshan Haider" schrieb im

Newsbeitrag
...
Hi Don,
I depend a lot on my system clock, therefore, I never disturb it.

I
am in
Pakistan and it has been set according to Pakistan Standard Time.

Outlook
Express is wise enough to convert other countries' time into PST

(Pakistan
Standard Time).

Perhaps your computer's system clock is faulty or your

newsreader's
settings
are disturbed. Presence of a virus cannot be ruled out.

Anybody else on this for got this problem?

With due respect Don, please try to avoid off-topic questions or

mail
me
directly, if it is necessary. I was quite busy today with my

project
and I
had to complete it by evening. That's why I was very active on

the
forum.

Regards!
--
Syed Zeeshan Haider



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

"Don Guillett" wrote in message
...
My computer shows your system clock may be off or is it

possible
you did
it
on purpose to stay at the top of the list?

--
Don Guillett
SalesAid Software

"Syed Zeeshan Haider" wrote in message
...
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