check

I need code to check if a cell in column F contains certain text. I then need to apply colour formatting to the entire row. Can someone help me please?

Hi, In my Dashboard sheet I have totals that feed through from each of the client sheets. Next to these totals, in column G, I have check boxes. I would like a saving macro to run if the check box is ticked. So; Sheet1 (Dashboard) Check box ticked - save pdf file of Sheet4 (Cordis) Check box...

Hi I want to prevent the SelectionChange procedure from running if the user pressed the TAB or RETURN key to get to the cell. How do I check for the last key pressed ? Thank you in advance. Al

HI Everyone, I need a macro to align my results in same sheet according to last maximum used rows from multiple columns. I have given image link that how am expecting result that will give exact idea. Please check and do the needful your support will be very helpful for me. Image link given...

Hi, Is it possible to check if a column of data is TAB delimited, can someone help with this please

Is there a windows api function to check the data type of the last item focused on or clicked down on (this includes a dragged object) is of the outlook object type? For instance, if you clicked on your desktop icon to drag it highlights to show its been selected and when you select an email in...

Please find the below code to understand my question: Set tbl = Sheets("Employee Leave Tracker").ListObjects("LeaveTracker") My table "LeaveTracker" has start date in column 2 and end date in column 3. I want to check, if the user input (through calender - DTpicker) falls with the range of...

Hi, I have a spell check macro for my password protected sheets. I also have a userform with a few last inputs (in some text boxes) by the user and these are to be sent to the spreadsheet. This will be the last part of the job card for the user to complete before printing the job card (as PDF)...

Hi! I have a table with many rows, columns and formulas. I'd like to use a formula to check if the cells referenced in formulas, are in the same row. For example, if I have a formula like this: =IF(AND(ISBLANK(S3);ISBLANK(U3));"";IF(AND(S3>0;U3>0);U3/S3;"Check the price.")) I'd like to...

Hi, sorry I am stuck, your help is very much appreciated. I am struggling to think of how I can use VBA to check for a number in a cell (string - e.g. 8, 11, 18). Then I would like to tabulate the total numbers into a table of how many cells contained that number. Here is how the data looks...

Hi Experts, In Excel when i go file - option - advanced - When calculating this workbook option-- check box - Use 1904 date system.. Can i know what is that and use?

=IF(AL2="",AND(OR(AD2="Coffee",AD2="Tea",AD2="Soap",AD2="Milk"),YEAR(AE2)>TODAY())) Hi, Can someone help me correct the above formula? AL: Column has words and blanks from inventory (Blanks remaining inventory, filled are sold) AD= Is the product we have AE= Date So if the AL column is...

Hi There, I need help to generate excel formula for below table.I need to put comments "value Zero" if my column"A" value nullify. below is the table. Please help me to get formula for this. <tbody> value Abs Forumal Comments -400 400 Value zero for 400 -400 400 Value zero for 400 400...

I have a check box to increase a quote by 10%. The formula is multiplied by a cell that contains a 1 or 1.1, depending on whether the check box is selected. I have the following code that won't work, what is wrong with it and what is a more efficient way to write it? Private Sub...

Guys, I am struggling with this.... I am trying to check if there are attachments in PR for service, but I can only check if my macro click to open the attachment table. In some cases, when there are not attachments, the SAP crashes because the macro opened the table where wasn't able to open...

Hello, I'd like to check if a word contains matching first/last letters from 2 cells. I can't quite get it to work. In fact, it doesn't work at all - I over sold 'quite'. Eventually I will check MANY words for MANY different first/last matches so I want to automate obviously. Example data...

I am looking for code that would look at a column, and if the cell is greater than "0" it would recheck the check box when the form is opened.any help would be appreciated.

I have a user form that include a check box. If you check the box it runs formulas and puts data in a different column than if it isn't checked. When I open the user form if there is data on the sheet it pulls it in to the user form, and you can modify as needed, however it does not recheck the...

I have the below formula I am trying to use to let me know if a person is supposed to be making specific adjustments. Right now every cell is showing "Check Adjustment" and the ones that are allowed to make adjustments are showing their names. I am wanting the cells to be blank if not an "RV"...

I'm sure the answer is simple, but I haven't found the right search terms to find it! So I'll just ask it here instead! :-) I've declared several worksheet variables as global parameters to use across several VBA subroutines: Public ThisWS, ThatWS, TheOtherWS as Worksheet and then set...