Userform not adding data to correct place

**Ms2BSwagg** · 01-12-2018, 05:34 PM

Hi

I need the user form to add the data to the correct rows and columns on Invoice Data - at the moment the values are not pasting in the right columns and rows, also it's not adding it to the table as extra lines when it's full. Have a feeling it has to do with defined names in name manger the spacing specified for each defined name might be incorrect.

also, there seems to be a #value error with Invoice Main for units 10,2,3 not sure whats going on there. Thought it was calculation cuz it had credit but there are others that have credit but they work.

Thanks again for helping out.

**Sintek** · 01-13-2018, 03:42 AM

Not to sure which columns you want to be populated...
Have a look at this old upload of yours...The above one has to many weird things going on...

Private Sub cmdAdd_Click()
Dim lUnit As Long, tblrow
Dim Tbl As ListObject
Set Tbl = Sheets("Invoice Main").ListObjects("InvoiceMain")
lUnit = cboUnit.ListIndex

If Trim(Me.cboUnit.Value) = "" Then
    MsgBox "Please enter a Unit ID"
    Me.cboUnit.SetFocus
  Exit Sub
End If

With Tbl
    .ListRows.Add
     tblrow = .ListRows.Count
    .DataBodyRange(RowIndex:=tblrow, columnindex:=1).Resize(, 4) = Array(cboUnit, cboUnit.List(lUnit, 1), _
    cboDescription, txtDate, txtAmt)
End With

cboUnit = ""
cboDescription = ""
txtDate.Value = Format(Date, "Medium Date")
txtAmt.Value = 1
cboUnit.SetFocus
End Sub

**Ms2BSwagg** · 01-13-2018, 05:15 AM

Hahhhahhahah i like weird - :P

Thanks will have a look. Much appreciated

Do you know why I'm getting the #value error on the Invoice Main for units 10,2,3?

Userform not adding data to correct place

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Userform not adding data to correct place

Re: Userform not adding data to correct place

Re: Userform not adding data to correct place

Thread Information

Users Browsing this Thread

Similar Threads

INDIRECT(MATCH...) Formula pulling into correct place but not correct value

add in userform wont place data on another workbook

[SOLVED] Userform doesn't apply data in correct place! Please HELP!

[SOLVED] Code to place userform data into next empty row

Check that the date is correct on a Userform prior to adding to spreadsheet

[SOLVED] Problems selecting correct data after filter is in place

Userform finding next row to place data

Bookmarks

Bookmarks

Posting Permissions