+ Reply to Thread
Results 1 to 5 of 5

Able to edit the cell that use drop down list

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Able to edit the cell that use drop down list

    Hi all, need some help in Macros,

    Required cell with drop down list function to be edited after function applied.

    For example, one of the choice in drop down list is 'submitted". I selected that however i wish to add DATE in front of 'submitted'.

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Able to edit the cell that use drop down list

    Do you mean this?
    Naamloos.jpg
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    10-17-2018
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Re: Able to edit the cell that use drop down list

    Hi Dotchiejack, nope that is not what i meant.

    on the cell i can choose what i wish to type from the drop down list. However, everytime i choose something from the drop down list in the same cell i wish to type in today date as well

  4. #4
    Registered User
    Join Date
    10-17-2018
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Re: Able to edit the cell that use drop down list

    Hi Dotcheiejack,

    Sorry for the previous post, but yes this is what i need. Do you know how i can input multiple drop down list selection in one cell?

  5. #5
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Able to edit the cell that use drop down list

    Look into: How to make dependent dropdown lists in Excel. or How to make Multiple Selections in a Drop Down List.
    see examples
    Last edited by dotchiejack; 10-22-2018 at 04:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Update cell list based on Drop down List
    By eaflynn in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2015, 03:48 PM
  2. Macro to EDIT Drop Down List
    By mithusaini in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2015, 07:06 PM
  3. [SOLVED] Edit a drop down list contents
    By worthm in forum Excel General
    Replies: 2
    Last Post: 12-18-2014, 06:21 PM
  4. Edit Drop Down Menu List
    By David A in forum Excel General
    Replies: 5
    Last Post: 01-10-2014, 12:59 AM
  5. How to edit a drop down list?
    By IPreferWord in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2009, 01:19 PM
  6. [SOLVED] how do I link a drop down list entry to a new drop down cell?
    By lmunzen in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 12:05 PM
  7. [SOLVED] Drop down list error after edit
    By theslaz in forum Excel General
    Replies: 5
    Last Post: 06-22-2005, 08:05 PM

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