Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ADDING/DELETING SHEET Without losing focus? | Excel Discussion (Misc queries) | |||
Excel losing focus, but remains active ! | Excel Programming | |||
Updating Cells w/ Userforms | Excel Programming | |||
Set Focus on Control at Creation in Dialogs, I mean UserForms | Excel Programming |