Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula is being quirky | Excel Worksheet Functions | |||
SUMPRODUCT Formula quirky.... | Excel Discussion (Misc queries) | |||
Quirky Problem With Links & Excel Versions | Excel Programming | |||
Quirky Code | Excel Programming | |||
Quirky Button | Excel Programming |