abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,438
- Office Version
- 2019
- 2010
- Platform
- Windows
hi
I would when run the userform I would show the last entered data .
in pic 1 when enter data from the first time
in pic2 enter new data
\
pic 3 it populate the last entered data with ignore the old data
this is the current code to show all of data
thanks
and so on if I enter new data it will populate new data in listbox with ignores the old data
note: if you want depending on date to do that I don't mind . it's up to you how should do it.
I would when run the userform I would show the last entered data .
in pic 1 when enter data from the first time
in pic2 enter new data
\
pic 3 it populate the last entered data with ignore the old data
this is the current code to show all of data
VBA Code:
Private Sub UserForm_Initialize()
Dim LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row '<---- ??????
With ListBox1
.ColumnCount = 6 '<---- Change to 18??????
.ColumnWidths = "70;70;100;70;70;70" '<---- 18 x each column width
.List = Range("A1:F" & LastRow).Value '<---- Change the "I" to the column number used above ( S = 18)
End With
End Sub
and so on if I enter new data it will populate new data in listbox with ignores the old data
note: if you want depending on date to do that I don't mind . it's up to you how should do it.