recognize

Hey all, Is there a way to make a macro recognize that a check mark has been checked? and if so what is it? I am trying to have a few check boxes select different ranges and a button copy those ranges and then paste them elsewhere. Thank you in advance.

Hi there, I was wondering how can I use a parameter in a query using the "Get & Transform" . For simplification purposes, I have a saved query called 'dbQuery': select * from Balances where Balances.CoprID=[Idpara] IdPara is the parameter. "Get & transform" doesn't recognize this query because...

Below is the current If statement that I am using-- Sample of file format: A B ColumnC ColumnD ColumnE ColumnF ColumnG 62 Task 1 $500 63 Task 2 $850 64 Task 3 $900 What I am trying to do: If ColumnC = "Yes" then "Recognize Revenue OVERTIME". If...

I currently have this formula in a cell. It requires people to enter x for the calculation to take place. How can I change it so it will calculate as long as any character is entered into the cell? =SUMPRODUCT(--(Q7:T7="x"),CHOOSE({1,2,3,4},E7,H7,K7,N7)) TY in advance

Does anyone know how to write coding such that excel will recognize the first time a particular file is opened on a computer? Situation- I have a fairly self-automated workbook/program I’ve written that does a lot on its own with menus and calculations and all- all written in vba- but I’d like...

Hello everyone, I am using excel 2007 In sheet "DASH BOARD" cell E26 have this formula =COUNTIF('PROJECT TRACKING'!CM6:CM304,"In Process"). it works great Could this formula be edited in cell E30 same range =COUNTIF('PROJECT TRACKING'!CM6:CM304 recognize only the abbreviated text of a date...

I know this isn't an Excel question but something happened over the weekend where my computer won't restart. I get a message that there is something wrong with my C drive and it tries to fix it on the fly. However, I can a message that it can' be fixed and gives me some option. I do have the...

If the contents of a cell start with ', I'm trying to change them using VBA - the first step being to delete the single quotation; however, I'm having trouble getting VBA to recognize the single quotation in the below If statement: If Left(cel.Value, 1) = "'" Then ..... - I tired cel.text as...

I want to display a column of numbers with " representing inches. I cannot type this into the cell directly as excel will not recognize them as numbers for my formula that I need. How would I go about this? Thanks for any help in advance!

Can Excel recognize colors?

Hello -- I have a workbook with multiple hidden worksheets. There are varying circumstances when the user would be expected to fill out any of them. Is there an easy way to make the workbook recognize if Cell A1 = XXXX, then sheets X, Y, Z are shown; if Cell A1 = YYYY, then Sheets A, X, Y are...

Hello, I have created several functions in VBA that operate on arrays created by other functions in VBA, however they don't recognize cell ranges as arrays. For example, the UBound function doesn't work with a range argument within my function. How can I get my functions to recognize cell...