Last two columns dot displaying in user form

  • I have created a simple data entry form to enter data. It has eleven columns in the database but only displays nine columns in the user form. The last two columns, J and K do not display in the user forum. The last two columns are auto generated when the user clicks save.

    The form is working and adding the data to the database properly, but the last two rows are not displaying in the user form.

    Can someone tell me what I did wrong?

  • Here is the code

  • Set the width of the columns to a better "to fit" size.

    I am new to coding so I am not sure.

    I am not familiar where to find or use "to fit". I have scroll bars, so as long at the data post I should be able to scroll to the left and see it?

  • mrcapi937 welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Note: no apostrophe in the tags, just used for demonstration here.


    your code goes between these tags


    Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • Attach an example workbook. I would not use RowSource

    If iRow > 1 Then
    .lstDatabase.List = "Database!A2:I" & iRow.Value
    .lstDatabase.List = "Database!A2:I2"
    End If
    End With
  • Try this, you don't refer to ranges like that in VBA

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!