SheetSelectionChange when modal form is shown

A

Alex Simachov

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't show non-modal form when modal form is displayed 5
Access MODAL form does not seem to act "MODALLY" 6
modal dialog, center outlook window, disable outlook window 4
Window Focus 0
How to detect when user switches between open forms? 10
Modal/Dialog form problems - Some info 0
FileDialog (FilePicker) doesn't work when word is minimized - a bu 2
Creating a menu on Access 2007 form 0

Top