LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula is being quirky Pierre Excel Worksheet Functions 10 July 24th 07 05:35 AM
SUMPRODUCT Formula quirky.... j razz Excel Discussion (Misc queries) 5 March 28th 07 11:36 PM
Quirky Problem With Links & Excel Versions MDW Excel Programming 1 July 7th 06 05:16 PM
Quirky Code bodhisatvaofboogie Excel Programming 2 June 26th 06 02:18 PM
Quirky Button nbs Excel Programming 0 September 2nd 04 07:27 PM


All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"