+ Reply to Thread
Results 1 to 3 of 3

Open a dialog box while clicking a cell

  1. #1
    Registered User
    Join Date
    02-23-2010
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    5

    Open a dialog box while clicking a cell

    Hi,

    I have a table with few categories (schedule, quality etc ... )
    Each cell is filled in color according to the status (Green,Yellow,Red)
    I would like to have the ability to press on specific cell and get a dialog box open with details of same category.

    Any ideas ?

    Thanks,
    Sharon

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Open a dialog box while clicking a cell

    Do you mean like having a data validation list you can choose from?
    What you want is not really clear to me.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Open a dialog box while clicking a cell

    You can write a sheet specific macro. that will run on double clicking inside a cell.
    right click on the tab at the bottom of excel that has the name of the sheet. Select view code.
    VBA will open
    select on double click at the top right of vba [ Just below the vba tool bars ]
    Paste your code within the macro that will be created by vba for you.

+ 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