Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. getitdaily

    Excel Macro Error: Procedure too large

    I recorded a macro in Excel and it worked fine on my PC. I emailed the macro to another person and when she ran the macro she got a Compile Error stating 'Procedure too large'. Anyone know what this means?
  2. getitdaily

    Excel date problem

    Read through this, it might help. http://www.fontstuff.com/access/acctut09.htm
  3. getitdaily

    Check activecell against a range

    I want to run a command line only if the active cell that is double clicked is in a range. How do I check the active cell against a range?
  4. getitdaily

    Double click in an Excel cell

    Is there a VBA command that lets you control what happens when you double click a cell in Excel?
  5. getitdaily

    Display a calendar after clicking in a cell

    Not quite what I'm looking for. I want the user to click on a calendar day and that day to be entered into the cell.
  6. getitdaily

    Display a calendar after clicking in a cell

    I have a range of cells B1:Bxx that hold a date. The user inputs the date but I'd like to display a calendar for selection after the user clicks in the cell. Any way to do this?
  7. getitdaily

    Macros in Excel

    I assume you're doing a Macro in Excel. If you are, the idea of a Macro in Excel is that you go through and make changes or actually do things to a spreadsheet or multiple spreadsheets and then stop the Macro once you're done. Then you can repeat the steps by just running the macro. You can...
  8. getitdaily

    Find Unmatched Query problem

    I have two tables that have a composite primary key. Dept and Name are individual fields, but combined they create a unique row in my tables. I'm trying to run a Find Unmatched Query on those two tables and was wondering why I can't select both fields when the wizard asks "What piece of...
  9. getitdaily

    Change Sign formula in Excel

    multiply by -1, so simple, yet so far away. Thanks,
  10. getitdaily

    Change Sign formula in Excel

    If the sign is + change it to -, if the sign is - change it to +
  11. getitdaily

    Change Sign formula in Excel

    I've looked through all the formulas and I may have overlooked it, but.... Is there a formula in Excel that changes the sign of a number in a cell???
  12. getitdaily

    Macros in Excel

    You probably don't want to try to write the macro yourself in the VBeditor. You need to find out what you need to do, then record those steps after you start running the macro. By the way, if you tape toast, buttered side up on a cat's back then if the cat landed on its feet the buttered side...
  13. getitdaily

    Blank field in query

    I need to pull field one and field two, with a column in between that doesn't exist anywhere. I would like to add a column in the query and fill it with the value 0.00. How do I do that?
  14. getitdaily

    Change authentication mode

    thanks
  15. getitdaily

    Change authentication mode

    How do I change the authentication mode that was asked during install once SQL Server has been installed?
  16. getitdaily

    Problem creating a fourth partition

    I'm trying to set up a fourth partition on a new server. I get three created then I don't have the option to create the fourth. Microsoft says it's a known problem. Anyone ever get this problem?
  17. getitdaily

    Reference a sheet that might not exist

    I have a couple of workbooks our accounting dept enters info into manually once a month. I am trying to eliminate the manual process with macros that input that data from the reports they key off of. In the first workbook I create a new sheet which the accounting department will rename after...
  18. getitdaily

    Reference a sheet that might not exist

    I'm trying to reference one cell to a cell in another sheet that might not exist. Anyway to do that?
  19. getitdaily

    formula in one cell places value in another?

    Sounds like a macro will be a good shot at what you want. Will you create new sheets and just copy the format?
  20. getitdaily

    formula in one cell places value in another?

    in b1 use this =IF(A1="","",A1/10) If A1 is null put nothing in B1 if A1 has a value then do a calculation in B1. This won't check to make sure A1 is a number, but the user should get an error if A1 has something like 'test'. If the user leaves A1 blank and just fills in...

Part and Inventory Search

Back
Top