LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default ActiveX comboboxes on worksheet (lost focus problems)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie Lost with comboboxes and dropdowns in excel bwall Excel Discussion (Misc queries) 1 September 7th 05 01:18 AM
Address of Cell that lost focus? HotRod Excel Programming 7 April 27th 05 02:39 PM
Textbox focus lost Stift[_25_] Excel Programming 7 June 7th 04 09:58 AM
Problems with worksheet containing ActiveX controls Deane Yang Excel Programming 1 August 21st 03 04:36 AM
Cell Lost Focus Craig[_5_] Excel Programming 1 July 23rd 03 05:18 AM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"