+ Reply to Thread
Results 1 to 6 of 6

type in selected cells only

  1. #1
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    42

    type in selected cells only

    Hello fellow members,

    I am unsure how to set certain cells to input data only in a worksheet.
    with the additional info in certain cells which i would like to avoid.
    i want to set this to only put in data in the highlighted cell from top to bottom in each category then move to the next category typing into the highlighted cells as required.
    I would love someone to help me set this up for ease of use.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,236

    Re: type in selected cells only

    Hi, how about unlocking the cells you want to allow data entry (right-click Format cells and in the tab Protection make sure there is no checkmark if the cell has to be available.
    do this will all those cells.
    Then protect the worksheet and allow only to select unlocked cells.
    No need for a password unless you don't want others to unprotect the worksheet
    Hope this points you some way in the right direction
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    42

    Re: type in selected cells only

    thank you, I will try that.
    I have used forms in the past that has this formatting already in place.
    however I was unaware that the sheet needed to be protected with the cells unprotected in this way.
    I have set my selection to move to the right (direction) after pressing 'Enter', would this upset the direction i want to go?
    i.e to type in cell c3, d3 and f3 then to move down to c4, d4 and f4. Once category #1 is filled down the page to c14, d14 and f14;
    I should move to the next category#2, either by selecting the category # 2 column manually or automatically to - j3, k3 and m3 and down to j4, k4, and m4 as far as j14, k14 and m14.
    Last edited by Por2gal; 06-28-2020 at 07:42 PM.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,236

    Re: type in selected cells only

    This is not about forms but worksheets
    You cannot protect userform filed, only lock then against editing

  5. #5
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    42

    Re: type in selected cells only

    when I say forms, I do mean pre-formatted forms on a worksheet,
    I was hoping to perform a similar formatting by typing in a cell and after clicking enter be able to type into the next cell to the right, as I click enter again, it should go down to the next row but in the same column, within the same boxed group. without having to use my mouse; can anyone help me or explain how I can set this up? I dont really know what to call it

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,236

    Re: type in selected cells only

    The Enter key behaviour is set in the general Options in Excel itself.
    There you can tell it if you want to go to the next column or the next row.
    Depending on the fact that if the worksheet is protected then it will select the next unprotected cell.
    With a macro embedded file, you can do much more and program what it should do depending on which cell has just been filled
    Attached Images Attached Images
    Last edited by Keebellah; 07-01-2020 at 03:42 AM. Reason: added image

+ 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. Assign a type to a selected portions
    By jackee1234 in forum Excel General
    Replies: 2
    Last Post: 04-14-2018, 03:41 AM
  2. [SOLVED] Cell Value Change dependant on Product Type Selected
    By essxmark in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-17-2015, 11:29 AM
  3. Export Cells to Text and automatically have File Name and File Type Selected
    By bloomingcarrot in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-18-2014, 03:37 PM
  4. Type Mismatch when trying to offset from user selected value
    By cmurda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 11:16 PM
  5. UDF - RSQ based on selected regression type
    By MrJim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 03:03 PM
  6. [SOLVED] unable to type in selected row
    By Andersenjoy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-24-2005, 11:06 AM
  7. Replies: 1
    Last Post: 05-23-2005, 05: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