+ Reply to Thread
Results 1 to 2 of 2

Help! This code isn't working"

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    SP, Brasil
    MS-Off Ver
    2010
    Posts
    1

    Help! This code isn't working"

    Hi! Im new here. Im from Brasil, so my english may be bad.

    Im working in a code for a form. In this code, the user need to enter 2 variables : "Grupo" (a 6 numbers data) and "Cota" (a 3 numbers data). After that, the code need to check in the worsheet if this specific combination of grupo and cota (let's call this the g/c) hasn't been imputed yet. If this specific g/c exists in the workcheet, i whant the user to see a msg called "Já_Existe", if this g/c dosn't exist in the worksheet i need the code to imput this new data.
    Take a look in what i have here:

    Please Login or Register  to view this content.

    If the especifi g/c exist, all comes out great, the user can see a msg saying that there already exist this g/c, but, when a new g/c is inserted, all my excel crash down. What im i doing wrong??

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Hugo_rmm,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. VLOOKUP not working for sheet 1 called "2016" in "Jobs.xlsx"
    By A2G in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-19-2016, 11:53 AM
  2. Replies: 9
    Last Post: 10-08-2014, 04:39 PM
  3. [SOLVED] trying to understand why a code is not working "error 9 subscript out off range"
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2013, 12:33 PM
  4. Form VB stopped working once I added a few line, "Form" Code Problem
    By amaro5211 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2013, 10:50 PM
  5. vba "evaluate" code not working
    By chiidzzz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2013, 08:32 AM
  6. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  7. VBA code "Application.FileSearch" not working in XL 2007 anymore
    By leecs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2010, 01:22 AM

Tags for this Thread

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