View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Simachov Alex Simachov is offline
external usenet poster
 
Posts: 1
Default SheetSelectionChange when modal form is shown

Hi All,

Could smb say what I'm doing wrong - I need get data from a worksheet
in way similar to the Refedit works.
I launch my dll from VBA code and create custom window.
I tried working with ExcelApplication.SheetSelectionChange - all works
ok, but I've problems if my window isn' t modal - controls loose focus
and keys pressed are sent to the Excel app.
I've created modal window (at Delphi I used DataForm.ShowModal) BUT I
don't have any SheetSelectionChange
callbacks.
Should SheetSelectionChange work when modal window is shown?

Thanks,
Alex