Thank you. You provide easy to understand instructions, and I appreciate it. I've not asked anyone online yet, but I have a question- If possible, how does one create a button to copy a range of cells if certain conditions are met? Example- If d6 is empty, copy a11:a17 If d6 contains text, copy b11:17 If d4 contains text but d6 doesn't, copy a11:a17 and c11:c12 If d4 and d6 contains text, copy b11:b17 and c11:c12
Thanks for your comment. I'm gonna have to take a look at your problem and it will take time. I'm having issues with my PC so can't work right now. I will get a new pc soon and after that i'll try to solve your problem. Please subscribe and be in touch.
Your tutorials are so good! I had been struggling to follow other online tutorials but yours are so easy to follow. Thank you very much for doing what you are doing and sharing your knowledge.
Thanks for your appreciation. This is all i need to keep going. Please subscribe and share these resources with your friends. This will help me a lot. Thanks again for excellent comment.
Thank you so much! I want to learn how to enable another cell in the same sheet or another sheet (in the same Workbook) appear the same data of the data that we enter in first cell. Thank you!
Great video. Is there codes possible to copy the whole sheet to another tab with the current date as the name for the copied tab and clear contents from the present sheet from the particular cells
Hello, this is a very good tutorial and thank you. I have 1 question, say i have a range of excel i wanted to clear but certain cells have to skip, is there a formula that i can use rather than writing range one at a time? For instance Range(“C1”, “C7”).clear but i need to skip c8 and c9 then include C10-C12. Is it possible to do it in 1 range? Thank you
Remove Clear to ClearContent in the code and that will keep the formatting and only delete the value. Hope you got your solution. Please subscribe and share this video with your friends.
Hi! Love this tutorial! It was very easy to follow but I have another issue. I have the cells I want to clear color coded. So when I click CLEAR button, it also delete the box color and border. How can I keep my color and border and also use the clear button function?? Thanks!!
Thank you for the video, However, i want to clear value of cell D6 only which is a merged cell of D and E column. I am getting error "We can't do that on merged cell". Any suggestion to fix that?
@@Excel10tutorial Thanks! Is it possible to clear both together with one button? I am trying to clear the following: D6 H6 H7 H8 D8 (Merged with column E & F) B13 C18 C19 C20 C21 C22 C23 C24 C25 C26
Ok, so I went back and tried it again. I created a macro as you did and by trial and error, I figured out how to apply the macro to the button. I would have NEVER considered messing with macros to apply to a button if not for you. Of all the tutorials I have seen, no one have ever so much as used the word "macro". All credit goes to this video. Thank you so much for knowing how to impart your knowledge!
Awesome tricks you just shared with the @excel10tutorial community. Thanks for that. It will really save time. Thanks a lot. Yet the way i demonstrated here will be helpful if we need to delete ranges that are separate from one another. Well at least that what i thought. Really appreciate your support. Thanks
Very helpful video. In my spreadsheet on some occasions I have ranges of cells, but also a single cell that I need to clear. How to I program the single cell? It is not a Range...
Thank you sir. It is easy to follow and I done it. but when I try to open again the file Clear Button doesn't work and have an error (Cannot run the macro. "filename'!Clearcells'. The macro may not be available in this workbook or all macros may be disable) then I check the Modules that I created but it is gone even I save it before closing the file.
Please explain your requirement. If you need to hide formula you can check this tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pN9yA6gvWzw.html
hello, is there anyway to: add a specific text to a cell when the button is clicked? I really have to do this in my project and I don't know anything of vba , thanks a lot great vid
Yes that can be done. Create a command button and write this code Private Sub CommandButton1_Click() Range("A1").Value = "the value" End Sub A1 is the cell where you need the value
Function ValidEntry_d() As Boolean End Function Sub Clearcells() Dim d As VbMsgBoxResult d = MsgBox("Are you sure?", vbYesNo + vbQuestion, "Clear cells") If d = vbNo Then Exit Sub If ValidEntry_d = True Then End If Range("A5", "A10000").ClearContents Range("B5", "B10000").ClearContents End Sub
Thank you for this wonderful session. But there is a problem, it clears all the things like data, formatting: border, colour etc.. I want to clear only data, not formatting like border, colour......Kindly do reply.
Here you go. this code will clear cell c1 to c5 of sheet 2 and the button will be in sheet 1. Subscribe and enjoy Sub Clearcells() Worksheets("Sheet2").Activate Range("C1","C5" ).Clear End Sub
@@Excel10tutorial Thank very much! I have experiment your code and it seems that if I had multiple sheet and they had the same content in cells, all contents in the sheets will also be cleared. But I would try this code of yours now! Thanks.
Yikes. This worked. I created a button to clear the cells and it worked great. The only problem is that the .clear function also wiped out all my formatting, color fills, data validation and conditional formatting. :(
The title said "...to clear specific cells..." you did a range of cells. I was thinking more along the lines of deleting something like B3 and D8, specifically.
But when sheet is locked and when we use this button.. the unlocked cells are being locked automatically..could you please suggest what could be done ??
On Request: How To Apply A Button To Clear Specific Cells On Another Worksheet In Excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-djEddntao9Q.html How to create a button to clear multiple merged cells in excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html
Good Tutorial, however you might want to add the fact that you will want to save this as an .XLSM File and not an XLSX. failure to do so will clear out all your macros that you've worked so hard on.
' I have protected my sheet but have the cells I have unlocked become locked when i clear the contents ready to use again. I don't want to keep going through my sheet to unlock all the cells again. The sheet needs to be locked to stop accidental alterations
@@Excel10tutorial I can do that but that is not my question. I have done that but when I add a button to clear contents it clears the unlocked cell and it becomes locked again. I want to stop this from happening
Thanks for the videos I would like to set an expiry date for my excel work book and then an activator incase some one buys it at the end of the expiry. How can I do this using excel? Or is there a way of putting something online to allow me activate the work book remotely without sharing another file with someone? I'll be glad to hear from you Thank you mwebazenicholas6@gmail.com is my email just incase it's needed