Results 1 to 9 of 9

Thread: run time error 13 Type mismatch

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6

    Compile erro:r Method or data member nor found

    please help me on this:

    Compile error
    Method or data member nor found



    Sub show_Numbers()
    
    Dim sh As Worksheet
    Set sh = ThisWorkbook.Sheets("Report")
    
    sh.Range("C1").Value = Me.txt_Start_Date.Value
    sh.Range("C2").Value = Me.txt_End_Date.Value
    sh.Calculate
    
    Me.Lbl_Purchase.Caption = sh.Range("C4").Value
    Me.lbl_Sale.Caption = sh.Range("C5").Value
    Me.lbl_Profit.Caption = sh.Range("C6").Value
    Me.lbl_Inventory_Qty.Caption = sh.Range("C7").Value
    Me.lbl_Inventory_Amt = sh.Range("C8").Value
    
    End Sub
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •