Clear Specific cells automatically after hit a save command button

**marifard** · 06-23-2020, 04:57 AM

Dear All,

I made a workbook with 6 worksheets. 3 of them are used to enter information into the other worksheets respectively. In these worksheets made two buttons one of them is used to copy the specific cells and paste them in another worksheet cells. The other one is used to clear specific cells. Both buttons works well but I wish when the user hit the save command button the cells clear automatically. I tried some codes to clear but they didn't work.

hereunder you can find the code that I used for the save command button and I attach the workbook too with this thread.

Please Login or Register  to view this content.

**Frankie_The_Flyer** · 06-23-2020, 05:28 AM

Looks like you need to merge and centre when you copy the new file name for a start. Only cell C3 appears to be being copied at the moment.

**marifard** · 06-23-2020, 05:36 AM

Originally Posted by Frankie_The_Flyer

Looks like you need to merge and centre when you copy the new file name for a start. Only cell C3 appears to be being copied at the moment.

all of the cells are copied. The issue is how to clear automatically the cells in SourceArr after the user hit the save button.

Thanks.

**Frankie_The_Flyer** · 06-26-2020, 12:05 AM

Hi marifrad

How about just calling the ClearSheetsForm macro (or other relevant macro) at the end of the code?

Please Login or Register  to view this content.

You can link the other macros to the save buttons on the other sheets.

May not be very clean but it works!

**sintek** · 06-26-2020, 05:37 AM

Try this..."New Doc Entry" Save Button...Amend for other buttons

Please Login or Register  to view this content.

**marifard** · 06-26-2020, 07:27 AM

Originally Posted by sintek

Try this..."New Doc Entry" Save Button...Amend for other buttons

Please Login or Register  to view this content.

Hi,

It works. I have another workbook attached with this post similar to the first one but I wish B20 in New Song Entry save as comment in A column instead. It is possible?

Thank you.

**sintek** · 06-26-2020, 07:31 AM

Hi marifard

No need to quote entire posts...Just clutters the thread...

but I wish specific column save as comment instead

Explain in more detail please

**marifard** · 06-26-2020, 07:42 AM

I wish cell B20 in New Song Entry worksheet saves as comment in column A in Scores List worksheet. It is possible with macro?

**sintek** · 06-26-2020, 08:11 AM

This will give you an idea..

Please Login or Register  to view this content.

**marifard** · 06-26-2020, 08:15 AM

Thank you. I tried to implement your code to save in this sheet but it takes me an error. can you guide me? I attach again the workbook.

**sintek** · 06-26-2020, 08:32 AM

With so many cells...loop is easier...

Please Login or Register  to view this content.

**marifard** · 06-26-2020, 11:45 AM

One last thing that I wish to modify. I wish that C6:C17 and F6:F18 didn't make them obligatory. I separate them from rng?

**sintek** · 06-26-2020, 01:45 PM

Change this snippet...

Please Login or Register  to view this content.

To...

Please Login or Register  to view this content.

**marifard** · 06-28-2020, 07:46 AM

Thank you sintek. I tried it and works perfect. One thing I wish to resolve. If I leave cell B20 in New Song Entry the code still makes a comment. It is possible if the cell B20 is empty, the code didn't make a comment?

**sintek** · 06-28-2020, 07:52 AM

See if you can figure this one out...

Put an If statement before this snippet of code...That checks if B20 is not empty

Please Login or Register  to view this content.

**sintek** · 06-28-2020, 09:47 AM

And...you get it right?

**marifard** · 06-29-2020, 01:48 PM

I'm feeling stuck about if statement.

**sintek** · 06-29-2020, 02:19 PM

Please Login or Register  to view this content.

**marifard** · 06-29-2020, 03:11 PM

It works

I made this

Please Login or Register  to view this content.

to clear these cells B2:B5, C6:C18, F6:F18. It is possible to apply it for B20 too?

Thank you.

**sintek** · 06-29-2020, 03:42 PM

Please Login or Register  to view this content.

**marifard** · 06-29-2020, 03:50 PM

the code gives me an error

Please Login or Register  to view this content.

**sintek** · 06-30-2020, 02:52 AM

That's because you are merging cells...
Rule No 1 in Excel...Steer clear from merging cells...Just causes havoc with vba...
Rather make use of Horizontal Alignment...
Anyway...This solves...

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED...
Thanks for Rep +

**marifard** · 07-01-2020, 09:48 AM

Another thing that I have an error. In the file that I attach, the macro gives me an error when I try to save in New Inv Entry worksheet. The error that gives me an error marked with bold

Please Login or Register  to view this content.

**sintek** · 07-01-2020, 11:10 AM

That is because your Invoice sheet was protected...Unprotect it and the code works...See attached...

I think it is time for this thread to be marked as solved...I am not going to sort out all your code for this entire file...

Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Re: Clear Specific cells automatically after hit a save command button

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using command button to copy cell contents and paste to different sheet, then clear cells

[SOLVED] Command Button to clear specific cells

Bookmarks

Bookmarks

Posting Permissions