+ Reply to Thread
Results 1 to 4 of 4

Unable to enter text in unlocked cells after selecting a value from a combox box

  1. #1
    Registered User
    Join Date
    05-09-2015
    Location
    United States
    MS-Off Ver
    2003
    Posts
    5

    Post Unable to enter text in unlocked cells after selecting a value from a combox box

    Guys,

    My entire sheet is protected except for few certain cells which I want the user to enter. One of the cell needs to be a combo box which will contain
    a list of Months. On click of a button, I am able to load the combo box with the months.

    Problem
    If I select a month from the combo box and then try entering value in the other cells - excel does not accepts the keystrokes.
    But if I don't select a value from the combox box and try to enter values in the cells - it just works fine.

    I am on a deadline, appreciate any help to fix this.

    I have attached the file I am working on, refer to the code for but 'ADD TOWN INFORMATION' (first button on the top left)

    Thanks
    Ivtej
    Attached Files Attached Files

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Unable to enter text in unlocked cells after selecting a value from a combox box

    Works fine for me.
    Can't replicate your problem. I select a month and fill the other cells fine.
    Please click the * below if this helps

  3. #3
    Registered User
    Join Date
    05-09-2015
    Location
    United States
    MS-Off Ver
    2003
    Posts
    5

    Re: Unable to enter text in unlocked cells after selecting a value from a combox box

    I am suprised to hear that. Let me try it on my other laptop and other version of Excel.

  4. #4
    Registered User
    Join Date
    05-09-2015
    Location
    United States
    MS-Off Ver
    2003
    Posts
    5

    Re: Unable to enter text in unlocked cells after selecting a value from a combox box

    It did work on the other laptop. Strange though..

    Thanks!!

+ 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: 5
    Last Post: 06-20-2014, 02:12 PM
  2. Hitting Enter in an unlocked cell without it advancing to the next unlocked cell
    By GuruWannaB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 09:47 AM
  3. Enter/Tab not working in unlocked Cells
    By beeawwb in forum Excel General
    Replies: 1
    Last Post: 05-03-2007, 10:25 PM
  4. [SOLVED] Selecting only unlocked cells to clear
    By RAP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2005, 10:04 PM
  5. Selecting and editing unlocked cells problem
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2005, 05:32 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