recognize

  1. E

    Making a Macro recognize Checkboxes

    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.
  2. U

    Get & Transform with a parameter from Access query

    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...
  3. O

    complex if/then and also reference another worksheet

    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...
  4. R

    recognize any character as oppossed to x

    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
  5. S

    Vba recognize first time startup

    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...
  6. J

    Countif range to only recognize text in a range

    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...
  7. B

    Restarting my computer

    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...
  8. M

    Trouble recognizing ' with VBA

    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...
  9. D

    Custom Number Format

    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!
  10. C

    Can excel recognize colors?

    Can Excel recognize colors?
  11. J

    Show/Hide Sheets Based on Cell Value

    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...
  12. K

    How to recognize a range as an array?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top