+ Reply to Thread
Results 1 to 3 of 3

Limit cell entry to drop down list items only

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Wales
    MS-Off Ver
    365
    Posts
    66

    Limit cell entry to drop down list items only

    Hi

    When I protect a Worksheet I want the user to be able to select a cell to choose items from a cell validation list but also to prevent free typing into the cell. I understand that the cell validation will result in a msgbox if the user enters something not in the list but I'd like to do away with that by preventing them from keying in the first place, simply to select from what's available.

    Is it possible?

    Thank you

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Limit cell entry to drop down list items only

    Why don't you use a Userform Listbox or Combobox instead?
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Wales
    MS-Off Ver
    365
    Posts
    66

    Re: Limit cell entry to drop down list items only

    Because I don't understand enough to include them in a worksheet table when I've got a VBA button to add new rows to a protected worksheet. Sounds like a heap of hassle...If it was in a UserForm I'd be fine.

    I think I'll just suffer the error message.

+ 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. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  2. [SOLVED] Force data entry in cell with drop down list (i.e. Prevent user from leaving cell blank)
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 05:28 AM
  3. Replies: 1
    Last Post: 08-01-2013, 07:55 PM
  4. [SOLVED] Apperance of selected items from drop down list in different cell
    By pointman787 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-25-2012, 12:28 PM
  5. How to limit entry in a field to just the drop down list
    By sparkes84 in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 06:41 AM
  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. Replies: 1
    Last Post: 01-27-2006, 02:10 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