+ Reply to Thread
Results 1 to 2 of 2

activating cell based on option selected

  1. #1
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    activating cell based on option selected

    Hello everybody,

    I have following problem. Can I activate any cell based on option selected.
    For example

    in cell A1 there is dropdown list and user is required to select one option out of two say Purchase Price, Notional Value.
    I want that user will enter date of purchase in cell B1 only if option selected is Purchase Price. If option selected is Notional Value , user need not enter any date. By dafault date 1st April, 1981 should get entered in cell b1.

    Can anybody tell me how to do this.

    Thanks

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520

    Activating cell based on option selected

    Hello,

    Can you attach an example file?
    Corine

+ 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