+ Reply to Thread
Results 1 to 4 of 4

On click malfunctioning (Excel 2007)

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    On click malfunctioning (Excel 2007)

    Good morning to all,
    I have a little problem and I cannot pin point it. The problem is in my Contracts tab. All codes are running perfectly except an unknown error that I cannot see.
    I have added an example in my Contracts tab. Every time a user adds a number in column B it will offset.
    There is an error that generates when I insert information in my Column D. Could someone help me to figure out this problem.


    Attachment includes my workbook. See with tabs Contracts and Report.

    Example.xlsm

    I will write a little explanation of what it should do and should not do.

    Been working so hard in this and now it's making stuff that is not writen, I don't get it.

    Thank you,

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: On click malfunctioning (Excel 2007)

    Explanation:
    My Contracts and Report interacts together only for one code. If a user adds information in column B the information will be transferred automatically to my Report sheet on the same row on the title in Column L. Kind of a mirror image.

    But when I insert information in Column D in my Contracts sheet it will add more information to my Report sheet and should not be doing this.

    It’s kind of looping on itself but there is no code telling to do this.

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: On click malfunctioning (Excel 2007)

    I have notice this is in every fields on the first row... Every time I either double click in a field, it will try to run a code that should not be running.

  4. #4
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: On click malfunctioning (Excel 2007)

    Found the problem... there was to many:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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