+ Reply to Thread
Results 1 to 5 of 5

Command Button not working

  1. #1
    Registered User
    Join Date
    03-10-2017
    Location
    Phoenix, AZ
    MS-Off Ver
    2013
    Posts
    18

    Command Button not working

    Hello, Cant seem to make my userform1 command button activate cell A1 in sheet2. The value I scan into sheet 2 is not showing up. My RFID is working because I can scan into cell directly and code populates sheet 4. But does not work from userform1. Help!!

    Userform1 code

    Please Login or Register  to view this content.

    Sheet 2 code

    Please Login or Register  to view this content.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Command Button not working

    Is the name of the command button, not the caption, but the (Name) ScanAssociateID?
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    03-10-2017
    Location
    Phoenix, AZ
    MS-Off Ver
    2013
    Posts
    18

    Re: Command Button not working

    Yes, the name is ScanAssociateID.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Command Button not working

    As far as I can see there's nothing in that code that will put a value in A1 on Sheet2/'AssociateTable'.

    This code will put the value from A1 on Sheet2 into the control AssociateID.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    03-10-2017
    Location
    Phoenix, AZ
    MS-Off Ver
    2013
    Posts
    18

    Re: Command Button not working

    Hi Norie, wouldn't my RFID scan directly into cell A1 if the sheet/cell were active? Then that cells value would be recorded into sheet4 report. Theoretically.

+ 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. VBA Command Button not working
    By CherryPie1544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2017, 07:49 PM
  2. [SOLVED] Active X Command Button not working
    By gassiusmax in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2015, 01:29 PM
  3. Command Button Stops Working After First Use
    By OpieWinston in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2014, 06:55 PM
  4. Command Button Not working in new file
    By Fletch74 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-05-2013, 11:41 PM
  5. Command button code not working
    By mariposa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2011, 05:03 AM
  6. [SOLVED] Command button is not working by using VBA
    By Webtekr in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2009, 02:22 AM
  7. command button isn't working
    By Nydia in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-29-2005, 06: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