View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default Quirky, infrequent problem with code


G'mornin Simon,

Thanks for looking at this. I guess I did forget something and that is the
button click command, but that's pretty straight forward...code is:

Private Sub CommandButton1_Click()

Unload UF2
Call Jul05

End Sub

I'm too am certainly not a whiz at this....I frequent here often for help,
either by postings or by searches through the archives.

As I said, this problem only happens infrequently and yesterday after
posting my question, I couldn't for the life of me get the program to
misbehave.....lol

I'll code the following into UF2's code and see what happens.

Private Sub UserForm_Activate()

CommandButton1.SetFocus

End Sub

Meanwhile, any other comments or suggestions would be appreciated,

Thanks again,

Don
"Simon Lloyd" wrote:


Don i'm no whizz at this but have you tried Set Focus to an item on your
UF2? maybe this will help..............maybe not, just a thought!

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=571064