clears

I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...

Is it possible to have a spreadsheet, whereby in cells B3:B22 (for example) you have "Hidden" answers, and in A1 you have a text box, you put an answer in, and press enter. If it matches, then it highlights the answer, and clears the cell for the next go. So, in B3:B22 you could have the...

I have a worksheet that i use for invoices. Once the invoice is printed i then press a button to run a macro which then clears the values that i have just typed into the cells. The code on the worksheet has just been changed but the macro which clears the cells is still the same. The problem...

Hi I managed to get some code which found any zeros in range G2:G500 and clear the cell, but now I also need a code that clears the cell beside it in column H. Is that possible? Thanks in advance

Hi, Using Excel 2016, I have a yearly workbook that is broken in to months, quarters, and year-to-date worksheets. At the start of each fiscal year (April to March), I want to give the user the ability to clear all of their data entries in the entire workbook at the click of a single...

Hello all This code clear cells in my worksheet called "Result" In row 15 from column "C:AA" there is a header in each cell If I run this code it clears everything ok but if I run it again it clears the header then every time I run it it starts clearing the row above. I think it has...

Hello. New to the MrExcel. I'm currently building a form that requires separate instances of cells being cleared based on cells from other worksheets changing. Private Sub Worksheet_Change(ByVal Target As Range) 'When E1 changes, E2 clears, and c20, d20 .... j20 all clear. If...

I have a form with about 10 check boxes on it that are ticked when answering the questions. I want a button that someone can press that checks all the boxes at once - i.e. a "yes to all" button. I also want one that clears them all as well. Can anyone suggest how to do this? Thanks :confused:

userform activex objects; my code; not working... "object required" error (I have also tried putting "Me." in front of the object names Private Sub chkBOX_Click() ' If CHECKBOX field is checked (Yes), then clear the TEXTBOX field contents: If chkBOX = True Then txtBOX.Value = Null Else End...

Hi I have a macro which clears data from cells A2 to H50,000. However, I would like to add a warning message which asks the user if they're sure they want to proceed with the action. If 'yes' then it proceeds, if 'No,' then nothing happens. My code is below with 'comment' additions of what...