UserForm not showing without alt-tab 
Author Message
 UserForm not showing without alt-tab

I'm running an Excel program in VBA that shows a
userform.  When the userform is shown, the application bar
(blue bar) at the top of Excel flashes until I hit alt-
tab, then the userform shows up.

Here is the code I'm using to show the form.  I set a few
parameters first: nLevels is a Long Integer and cValues is
a collection.

UserForm1.nLevels = nLevels
Set UserForm1.cValues = cGV
UserForm1.Show 1

Any thoughts about how to get the form to show without any
user keystrokes would be greatly appreciated!



Sun, 04 Sep 2005 22:12:56 GMT  
 UserForm not showing without alt-tab
By using the "repaint" method once the userfrom was shown.

Sun, 04 Sep 2005 22:44:07 GMT  
 [ 3 post ] 

 Relevant Pages 

1. make userform button respond without alt key

2. Defeating control escape, alt tab, alt esc

3. Alt-Tab instead of Alt-Window

4. Can't show an UserForm (Frm.Show False does not work)

5. Access97 sometimes does not close without Ctrl-Alt-Del

6. Workbook.Activate Event not firing when activate with Alt-Tab -- Why

7. window is not active Alt - Tab

8. Showing a userform without loosing the contents of the clipboard

9. Tab acts like Alt-Tab

10. ctrl-alt-delete not showing lock option

Powered by phpBB® Forum Software © phpBB Group