+ Reply to Thread
Results 1 to 4 of 4

clear the content inside the cell

  1. #1
    Registered User
    Join Date
    06-18-2007
    Posts
    9

    clear the content inside the cell

    +I've attached a picture for reference +

    I have a drop-down box on A2 and it has a range of numbers from 1-6

    if i select 2 in the drop-down box, it will hightlight the box in yellow.

    but there's one problem and that is previously i select 3 and type a date on A5 but now i select 2 and cell A5 doesnt clear the content in it.

    can i know how to clear the content inside the cell?
    Attached Images Attached Images

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Do you want to delete the value in cell A5 every time you change the value selected in A2? If so, you could use this code in the worksheet's code module:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-18-2007
    Posts
    9
    hmm.. not actually is A5 to be cleared.. is those not in the yellow box to be cleared..

    A3 and A4 is highlighted in yellow is because the drop-down box is 2

    if the drop-down box is 1, A4 and A5 should be cleared.

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    To get what you're looking for, you're probably going to have to specify what you want to occur when you select each number from the drop down list.

    What do you want changed when you select 1?
    2?
    3?
    4?
    5?
    6?

    Also, it doesn't appear your drop-down list is an in-cell drop-down (data validation). Is it a combo box off of the Forms toolbar or the ControlsToolbox?

    Thx

+ 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