View Full Version : Enter Data In Worksheet & Delete Empty Rows

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
My 100th Post. :friends:

06-22-2005, 02:28 AM
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)

Hi Sheeeng,

This all looks like a direct restatement of a homework problem or assignment.(?) Perhaps you'd better read our posting rules (click here (http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hom_faq_item)) and explain a little more about the quoted sentence first. You can PM me if you prefer...


06-22-2005, 07:36 AM
Sorry, let me rephrase it again. :doh: It is an example from my mind. Not a homework directly. Just trying out to implement it. Sorry again. :doh:
Help if allowed by Site Admin.

johnske, do i need to edit my original post? or delete it?

Sorry for all the unnessasary problem....
If help is not allowed, How do I delete this thread?
Pls tell me how to remove this thread if this thread is illegimate in this forum.

06-22-2005, 02:59 PM
Hi sheeeng,

No need to edit or delete your original post, it's always good to be completely up-front and say that it is homework.

It's not that we can't help at all with a homework assignment, we just treat the post in a different manner to the more usual post.

What I mean by this is that with a normal post someone may come up with a complete and specific solution for you, where-as with homework it's treated as a non-specific problem where we can give advice, links, and point you in the directions you need, and some may even offer solutions to some of the individual points but we won't put it all together for you - that's your homework... :devil:

So if someone wants to reply to this thread they know they can do so in a general non-specific manner. :thumb


PS congrats on your 100th post :) :thumb

06-22-2005, 06:44 PM
Thanks for the advice.
I appreciate it.
Thanks again.