+ Reply to Thread
Results 1 to 2 of 2

If user picks "Other" from dropdown menu, jump to separate cell to enter value

  1. #1
    Registered User
    Join Date
    11-24-2020
    Location
    Melbourne, Australia
    MS-Off Ver
    Microsoft 365 - Excel Version 10
    Posts
    1

    If user picks "Other" from dropdown menu, jump to separate cell to enter value

    I have a column where users pick a reason from a dropdown list.

    If they pick "Other", i.e. none of the reasons listed apply, they should be redirected to a cell at the end of the row where they have to enter the "other" reason.

    Cheers,
    Birgit

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: If user picks "Other" from dropdown menu, jump to separate cell to enter value

    Moving the user's selection to another cell requires VBA. Please provide more detail about where your dropdown list is located and where the end of the row is.

+ 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] Enter a Corresponding "Customer Code" Value to Cell Found on Separate Worksheet
    By windowshopr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-28-2017, 06:42 PM
  2. [SOLVED] IF CELL is "Yes" the enter "Enabled" IF CELL is "No" enter "Disabled"
    By king10001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2016, 09:33 AM
  3. Replies: 2
    Last Post: 12-19-2012, 06:47 PM
  4. if "a" selected from dropdown menu then show "K" in other cell
    By LEGALMATTERS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 01:10 PM
  5. save and restore "Workbook Menu Bar" & "Cell" menus
    By Jeff Higgins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2005, 10:08 PM
  6. Dropdown with a "jump to" cell name. Like a Go button..
    By thom hoyle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 04:06 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