Custom Menu Focus

  • Thread starter Thread starter Hank
  • Start date Start date
H

Hank

I have created a custom menu that work fine except ...
when double clicking on a cell to get focus to type in that cell. Then
the custom menu will not open.
I notice most of the other menus (font, print, file, etc) work fine when
this happens.
The reason I made the menu was to open a form that has prepared statements
to input into the selected cell. It is frustrating to stop typing in the 1st
cell- click on another cell - then click on the 1st cell again to input the
statement.

Where did I go wrong?

Hank
 
Hi Hank

Unfortunately, VBA code won't be run when focus is in the formula bar.
However, COM Addins do execute when focus is in the formula bar. I suggest
you convert your form to a COM Addin, using either the Office 2000/2002
Developer Edition, VB6 or .NET
--
Regards

Stephen Bullen
Take your Excel development to the highest levels
with "Professional Excel Development",
www.oaltd.co.uk/ProExcelDev
 

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

Back
Top