-
Hello, I am looking for some code which will return the location of the form button which is being clicked on th active the macro. I would like to avoid using an active.x button if at all possible. I can then use the same macro on a column of buttons to trigger an action based on adjacent cell contents...
-
Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
-
I use Excel 2007 and want to capture the last 8 digits of an accounting code located in cell A1. I put this formula =RIGHT(A1,8) in cell A2. According to the formula help information, my entry is correct. However, when I hit enter, the formula remains in cell A2. No results appear. Both cells A1 and...
-
I have written (and used for a number of years) a very controlling menu and stipulated multiple tasks with VBA. I have worked around it in 2007 using [alt][x] but am now finding this very time consuming and irritating (yes I AM old!!) It relates to a number of workbooks and worksheets and multiple changing...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
I have this IF - THEN question. Is it possible to write an IF statement that would take information and add it to the first blank space in a column? For instance: IF there is an "X" in A5, take the information in B5 and put it in the first blank cell in column A in Worksheet 2, then have that...
-
I'm working on a spreadsheet to output payslips for my father-in-law's company. (I'd hoped to build a whole payroll system in Access, but it's an... irregular system that doesn't lend itself very well to that.) Anyway, the workbook consists of two worksheets; one called "Payslips"...
-
Is there a way to password protect he quick access toolbar to prevent users from adding/removing buttons? Thanks in advance,
-
Hi I have a file which was created a few years back. For some reason im not able to remember the open password for the file. Is there any way out to decrypt this file so that i can open it with out password. Im trying to see if i can get some help here with out buying a software. Feedbacks i have on...
-
I have a spreadsheet with a number of conditional formats in it each one is based on different data, but for consistency's sake the colors have to align they are also laid out differently enough that I can't aggregate them together into one autofill-able formula (e.g. cells A1:C24, B30 and C45...