Results 1 to 6 of 6

Forms issue, get debug on save

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2012
    Location
    Netherland
    MS-Off Ver
    2010
    Posts
    9

    Forms issue, get debug on save

    Hello,

    i have two TAB's and two simple forms with one data entry field.

    i use below codes to save the dataentry but on one from i get a debug message.

    i don't know what is wrong here, does anyone has a solution.


    this is on the first worksheet / form and works fine

    Private Sub CommandButton1_Click()
    Dim iRow As Long
    Dim ws As Worksheet
    Worksheets("QC In").Activate
    Set ws = ThisWorkbook.Worksheets("QC In")
    
    'find  first empty cell in database
    
    iRow = ws.Range("A1").End(xlDown).Row + 1
        'copy the data to the Expanditure
    ws.Cells(iRow, 1).Value = Me.TextBoxQC_In.Value
    'Clear input controls.
        Me.TextBoxQC_In.Value = ""
        'activate cleaning macro
    Call CleanDupes
    End Sub
    this is on the second worksheet/ form and comes up with the debug on save, on the red line

    Private Sub CommandButton3_Click()
    Dim iRow As Long
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("QC Out")
    Worksheets("QC Out").Activate
    'find  first empty cell in database
    
    iRow = ws.Range("A1").End(xlDown).Row + 1
        'copy the data to the Expanditure
    ws.Cells(iRow, 1).Value = Me.TextBoxQC_Out.Value
    'Clear input controls.
        Me.TextBoxQC_Out.Value = ""
        'activate cleaning macro
    Call CleanDupes
        
    End Sub

    any help is welcome.
    Last edited by Nissort; 10-14-2018 at 05:49 AM. Reason: [Solved]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. .Insert debug issue
    By crackerjack- in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2017, 09:56 PM
  2. [SOLVED] Debug Issue Involving A Form
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2016, 12:13 AM
  3. [SOLVED] Debug issue Run-time error '91'
    By sammar12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2016, 09:51 AM
  4. Need help with debug issue with macro
    By Lylestyle89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2015, 01:36 PM
  5. debug issue
    By savithrianandh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2007, 09:51 AM
  6. VBA issue, debug
    By ophelia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2006, 05:45 AM
  7. Replies: 1
    Last Post: 07-16-2005, 11:05 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