+ Reply to Thread
Results 1 to 5 of 5

Text box wont accept numbers

  1. #1
    Forum Contributor
    Join Date
    07-08-2015
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    128

    Text box wont accept numbers

    Hi all

    I am stumped. I am working on the user form called InputRejectsUserForm. On this form, I have text boxes set up as txt; a few combo boxes; and 4 text boxes that named for integers: intRejects; intRtl; intOurs, intTheirs. The weird thing is that the 4 boxes I have set up as "int", will not show any numbers when I input them into their fields.

    So, for example: if I attempt to put in 76 in the Number Rejected box (it's gray) or any of the other integer boxes, it will not show up.

    Anyone figure out why? I have been looking at code and set up for hours now..........
    Thanks so much in advance


    PS; I do have checkers set up for those boxes so as to not get anything except a number, but that code I don't believe will have any affect on it.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Text box wont accept numbers

    Hey... what is the password?

  3. #3
    Forum Contributor
    Join Date
    07-08-2015
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Text box wont accept numbers

    hi all. password is QCAPPROVED all caps incase your assisting. I think it may be in the code checking to ensure only numbers are input, but I am not sure where the problem lies. I have used the exact code in other programs.

  4. #4
    Registered User
    Join Date
    05-11-2015
    Location
    West Cornwall, UK
    MS-Off Ver
    2010
    Posts
    55

    Re: Text box wont accept numbers

    Hi Scott,

    I have just changed the spelling of "your" KeyAscii = KeyAscci to KeyAscii = KeyAscii and I can now enter numbers into your textbox's.

    Give that a try.

  5. #5
    Forum Contributor
    Join Date
    07-08-2015
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Text box wont accept numbers

    Quote Originally Posted by TG58 View Post
    Hi Scott,

    I have just changed the spelling of "your" KeyAscii = KeyAscci to KeyAscii = KeyAscii and I can now enter numbers into your textbox's.

    Give that a try.
    THANKS! I knew it was something small and weird. To many distractions.

+ 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] Formula in one work sheet wont accept result from another in a different work sheet.
    By Belinea2010 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-07-2015, 12:24 PM
  2. Replies: 3
    Last Post: 10-21-2014, 10:35 AM
  3. File wont accept VBA
    By stin25 in forum Excel General
    Replies: 9
    Last Post: 07-02-2009, 11:36 AM
  4. Format cells to only accept numbers
    By cradino in forum Excel General
    Replies: 1
    Last Post: 07-22-2006, 12:08 AM
  5. adv filter wont accept criteria
    By daniel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2006, 04:15 PM
  6. excel 2002 wont accept my code on back of disk
    By racer in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-06-2005, 08:00 AM
  7. Does SUMPRODUCT only accept text and numbers?
    By Racorfrank in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-04-2005, 03:19 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