+ Reply to Thread
Results 1 to 8 of 8

Unable to type in cells after textbox gains focus

  1. #1
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Unable to type in cells after textbox gains focus

    I have a problem that's driving me crazy...and I'm sure it's a simple answer.

    In the attached file there is a Booking Form and Booking Sheet.

    If you open it you can see you can edit/type in each editable field (white background) on the Booking Form tab.

    If you make a change the 'Cancel Changes' button will be pressable.

    If you press 'Cancel Changes' the edited changes are reverted back to the original data. That all works fine.

    However, now if you click in the large text box (no need to type anything) and then one of the editable cells, you can now no longer type in any of them.

    If you change to the other tab and then back to the Booking Form tab you can edit the fields again.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: Unable to type in cells after textbox gains focus

    after clicking in the large textbox i can change de editable cells. Works fine here.

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Unable to type in cells after textbox gains focus

    It is only editable until you make a change and then 'Cancel Changes'. Then click in the textbox then try and edit.

  4. #4
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: Unable to type in cells after textbox gains focus

    ok, step by step:

    1. I change the last name
    2. I click on the "Cancel Changes"-button.
    3. I click on yes in the msgbox
    4. I click on the textbox ( textbox1)
    5. I still can change the last name etc.

  5. #5
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Unable to type in cells after textbox gains focus

    Well that's weird. I just tried it on a machine with Excel 2016 and it works fine, but not on my Excel 2013.

  6. #6
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: Unable to type in cells after textbox gains focus

    A bug probably, as you can see im running Excel 2016. I don't have the 2013 version.

    Good luck with it.

  7. #7
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Unable to type in cells after textbox gains focus

    Now I've just tried it on another 2013 machine with Standard Office and it works fine.

    The only difference I can see is that I have Professional Plus version.

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Unable to type in cells after textbox gains focus

    Hello kersplash,

    I have tried it in Windows 7 Office 2010, and all works fine. It might be that you do not have all the editable cells unlocked, before protecting the Sheet.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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] Pressing Enter on Textbox moves focus to next Textbox
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-11-2016, 09:37 AM
  2. textbox without focus
    By eugz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2014, 04:24 PM
  3. Focus on Textbox
    By seemanthv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2014, 02:38 AM
  4. [SOLVED] Textbox focus
    By tradinup2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2013, 12:25 AM
  5. setting focus on a textbox
    By Geordie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2010, 12:26 PM
  6. [SOLVED] Run macro when excel workbook gains focus
    By Perry in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2006, 07:45 AM
  7. How to tell what textbox got the focus
    By vqthomf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2005, 09:15 AM

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