Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
a) try putting application.screenupdating=false in the private subs,
too. b) you might have to programatically re-focus the focus. cboPersArea.set focus :) susan, not-a-guru On Feb 13, 10:41 am, wrote: Ok, new morning, fresh brain. Please correct me if i'm wrong but I'm thinking that the lost focus event of the cboPersArea kicks in after the next combobox receives focus. Therefore the next combo box is essencially losing focus which kicks off it's lost focus event so the two combos are fighting each other. I still don't know why the screenupdating isn't turning off but, at this point, thats a moot point. This means I'm in search of another event to make this work. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Newbie Lost with comboboxes and dropdowns in excel | Excel Discussion (Misc queries) | |||
Address of Cell that lost focus? | Excel Programming | |||
Textbox focus lost | Excel Programming | |||
Problems with worksheet containing ActiveX controls | Excel Programming | |||
Cell Lost Focus | Excel Programming |