sheeeng
06-22-2005, 02:09 AM
Hello all VBAExpress members :hi: ,
I'm facing this problem for my homework :fainted: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#). (pls view attachment)
1) I would like to scan / search through Sheet1 in Excel to row after last row. :confused4 (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
2) The ListBox in Userform1 must list all items available in column A :confused: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#).
3) How to change manually (by VBA macro code) the ListBox1 properties for BoundColumn, ColumnCount, Column Heads, ListSytle and RowSource? :SHOCKED: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
4) I need to enter data through 3 three text boxes for each Year, Month & Day from Userform1. :banghead:
5) Then I enter data into the row after last row that contains previous data.:stars: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
6) When searching through for last row before entering data, can delete when encounter empty rows.:doh:
7) Data had to be enter via form. Add and delete functions launched from form buttons. :bug:
Please help me. :help :help :help
Thanks.
My 100th Post. :friends:
I'm facing this problem for my homework :fainted: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#). (pls view attachment)
1) I would like to scan / search through Sheet1 in Excel to row after last row. :confused4 (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
2) The ListBox in Userform1 must list all items available in column A :confused: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#).
3) How to change manually (by VBA macro code) the ListBox1 properties for BoundColumn, ColumnCount, Column Heads, ListSytle and RowSource? :SHOCKED: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
4) I need to enter data through 3 three text boxes for each Year, Month & Day from Userform1. :banghead:
5) Then I enter data into the row after last row that contains previous data.:stars: (http://www.vbaexpress.com/forum/misc.php?do=getsmilies&wysiwyg=1&select_category=Confused+%2F+Surprised+%2F+Scared#)
6) When searching through for last row before entering data, can delete when encounter empty rows.:doh:
7) Data had to be enter via form. Add and delete functions launched from form buttons. :bug:
Please help me. :help :help :help
Thanks.
My 100th Post. :friends: