+ Reply to Thread
Results 1 to 5 of 5

Make suggestions based on typing

  1. #1
    Registered User
    Join Date
    09-28-2022
    Location
    Norway
    MS-Off Ver
    Latest
    Posts
    15

    Make suggestions based on typing

    Hello!

    I have a task where i input the status of an employee

    I often input the same text, but sometimes i have to input another text.

    How do i make inputting this information quick. Preferably i want a dropdown list, but it cant limit what data i can input, as the data might be customized. Does this rule out DataValidation?
    Attached Files Attached Files
    Last edited by Rubendg; 09-28-2022 at 06:59 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,324

    Re: Make suggestions based on typing

    Does this rule out DataValidation?
    It does not rule it out but it does, in my opinion, make it a waste of time.

    You can, I think, just have the DV without the Error Stop and message.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,012

    Re: Make suggestions based on typing

    If it's just speeding up your data entry, you could try something like this.

    https://portableapps.com/apps/utilit...rtask-portable

  4. #4
    Registered User
    Join Date
    09-28-2022
    Location
    Norway
    MS-Off Ver
    Latest
    Posts
    15

    Re: Make suggestions based on typing

    TMS : Thanks, this worked wonders!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,324

    Re: Make suggestions based on typing

    You're welcome.

+ 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. Need to make a Chart with Multiple Variables Need Suggestions
    By e4excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2018, 03:53 AM
  2. [SOLVED] make blank cells color fill after typing in text
    By oliver1712 in forum Excel General
    Replies: 4
    Last Post: 12-10-2014, 01:52 PM
  3. [SOLVED] VBA: How to make macro for typing specific (long) formula in cell ?
    By ChristopherH in forum Excel General
    Replies: 4
    Last Post: 03-24-2014, 12:59 PM
  4. Make a cell turn a color by typing a letter
    By stixmike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2012, 12:44 PM
  5. Can Excel create suggestions based on a range of cells?
    By Philanalyst in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2009, 07:50 PM
  6. Replies: 4
    Last Post: 11-22-2005, 06:30 PM
  7. Excel Filtering - Any Suggestions to make it faster...
    By Stuart Jones in forum Excel General
    Replies: 3
    Last Post: 07-10-2005, 10:05 AM

Tags for this Thread

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