+ Reply to Thread
Results 1 to 2 of 2

Custom Menu Focus

  1. #1
    Hank
    Guest

    Custom Menu Focus

    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



  2. #2
    Stephen Bullen
    Guest

    RE: Custom Menu Focus

    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


    "Hank" wrote:

    > 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
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1