Hello all VBAExpress members ,
I'm facing this problem for my homework . (pls view attachment)
1) I would like to scan / search through Sheet1 in Excel to row after last row.
2) The ListBox in Userform1 must list all items available in column A .
3) How to change manually (by VBA macro code) the ListBox1 properties for BoundColumn, ColumnCount, Column Heads, ListSytle and RowSource?
4) I need to enter data through 3 three text boxes for each Year, Month & Day from Userform1.
5) Then I enter data into the row after last row that contains previous data.
6) When searching through for last row before entering data, can delete when encounter empty rows.
7) Data had to be enter via form. Add and delete functions launched from form buttons.
Please help me.
Thanks.
My 100th Post.