NEED HELP! Code that checks all data has been entered before my VBA Macro Runs!

Hi guys,

I have the following macro which allows you to enter a row of data (Only one row will be visible), then you press a command button and the row of data is inputted into another work sheet.

* I would like a way of ensuring that Excel checks the whole row of data has been filled out before allowing itself to run the following macro (which copies and paste all the data across to the other worksheet).

Here is the code I have so far. (Just to advise this macro starts on the "AddRecord" sheet.

Please someone out there if you can help me I would be forever grateful!!! :D

Please Login or Register  to view this content.

Happy Easter!

12345678910

Hi, Dremzy,

welcome to ExcelForum. Please consider to wrap your procedure with code-.tags according to Forum Rulke #3 for better readability.

Ciao,
Holger

Hi Dremzy, welcome to the forums. Please take some time to read the forum rules if you haven't. Rule #3 in particular, you should use

Please Login or Register  to view this content.

12345678910

12345678910

Hi, Dremzy,

Your opening post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

12345678910

Hi, Dremzy,

I have also learnt how to place VBA in the forum.

But failed to do so in the opening post of this thread as you have been asked to do.

Is there a way i can delete this thread?

If I remember correctly the thread opener may delete a thread only if no answer has been given. If any answer to that thread has been given only Mods and Admins have the right to close or delete a thread.

This is a duplicate thread and I have resolved it in another thread.

Sorry but this is the first of the threads you posted. So how could this be a duplicate?

Ciao,
Holger

12345678910