View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
asiamood asiamood is offline
external usenet poster
 
Posts: 1
Default event in worksheet switches to VB code window

I have some VBA code that is fired by clicking on a worksheet. When the
Selection Change event is firec, the code deletes an activeX combo box
, recreates it, and then dynamically adds a keypress event for the new
combo box. The problem I am having is that after the event fires,
everything happens as planned except the worksheet loses focus and the
VB code window appears. any ideas on how to not let this happen?

Thanks


---
Message posted from http://www.ExcelForum.com/