Search results for query: *

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?

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

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?

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

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.

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?

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

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

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

If the sign is + change it to -, if the sign is - change it to +

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

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

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?

thanks

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

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?

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

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

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

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