View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mo_in_france[_2_] mo_in_france[_2_] is offline
external usenet poster
 
Posts: 3
Default Excel losing focus and non-updating userforms

Hello All,

I've a number of Excel VBA applications which require user input/
response, and I've got 2 commonly occurring issues, relating to what
maybe the same thing

(1) Dropdown comboxbox on a userform -
The user must select an item from a combobox, then the user then must
select another item from combobox (containing 10 items at least). My
problem, is that when the second combobox appears you can still see
the previous dropdown list (in its expanded form) on the screen.
Despite a combination of 'Unload' and screen updates, the original
dropdown list stays visible.
I'm pretty sure Im missing something stupidly obvious here.

(2) When msgbox appears, Excel loses focuses
When a msgbox appears, typically at the end of the program, when I
display something that indicates the end of the program, Excel loses
focus. That's to say, another program takes focus, and the Excel icon
on the application bar starts to flash, suggesting that Excel wants
you to click okay on the msgbox.
This seems to occur more on some users than others.

Any suggestions would be very helpful.