Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am receiving a run-time error "13" when I try to run a USerform in VBA.
When I try to debug the problem - I do not get an indication where the problem is. Below is the code. Does anyone see what might be causing the error? Private Sub cmdadd_click() Dim lRow As Long Dim lDate As Long Dim ws As Worksheet Set ws = Worksheets("Scrip Purchases") 'find first empty row in database lRow = ws.Cells(Rows.Count, 1) _ ..End(xlUp).Offset(1, 0).Row lDate = Me.txtDate.Value 'check for a family name If Trim(Me.cbofamily.Value) = "" Then Me.cbofamily.SetFocus MsgBox "Please enter family name" Exit Sub End If 'copy the data to the database With ws ..Cells(lRow, 1).Value = Me.txtDate.Value ..Cells(lRow, 2).Value = Me.cbofamily.Value ..Cells(lRow, 3).Value = Me.cbovendor.Value ..Cells(lRow, 4).Value = Me.txtdenomination.Value ..Cells(lRow, 5).Value = Me.txtquantity.Value End With 'clear the data Me.txtDate.Value = Format(Date, "medium date") Me.cbofamily.Value = "" Me.cbovendor.Value = "" Me.txtdenomination.Value = "" Me.txtquantity.Value = "" Me.txtDate.SetFocus End Sub Private Sub cmdclose_Click() Unload Me End Sub Private Sub UserForm_Initialize() Dim cfamily As Range Dim cvendor As Range Dim ws As Worksheet Set ws = Worksheets("Lookuplists") For Each cfamily In ws.Range("familylists") With Me.cbofamily ..AddItem cfamily.Value ..List(.List - 1, 1) = cfamily.Offset(0, 1).Value End With Next cfamily For Each cvendor In ws.Range("vendorlists") With Me.cbovendor ..AddItem cvendor.Value ..List(.List - 1, 1) = cvendor.Offset(0, 1).Value End With Next cvendor Me.txtdenomination.Value = "" Me.txtquantity.Value = "" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On Errror Goto Error handler only works first time through "For Each" cycle | Excel Programming | |||
Validation question - allow -500%, 0%, "=50%*50%" but forbid "A", "", " ", "-" ? | Excel Programming | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch" | Excel Programming | |||
"Can't Show Modally" - Run-Time Error '400' Problem | Excel Programming |