| Thread | Last Post | Replies |
|
| auto set time(now) if criteria=true with no later change | 25 Apr 2007 00:34 GMT | 1 |
I am using excel to manage a continues progress report on a data base of users. The report includes set of stages that the users are going through. Each time a define criteria set on (true), the user is moving from one stage to the next.
|
| Executing a VBA macro from within Excel 97 script | 24 Apr 2007 23:44 GMT | 1 |
I am running Excel 97. I have an application in it that is written in the macro scripting language. The application works very well. I also have a VBA macro that works very well when I execute it manually. However, I would like to execute the VBA macro from within the application ...
|
| Problem with Auto Filter and Macro | 24 Apr 2007 23:37 GMT | 1 |
I have a macro that was rud fine until data was added to one of the tabs. The data was added to data that was already on the data, at the bottom. The proble we are having now is that the macro is not seeing these data and even when we run the auto filter on one of the columns in ...
|
| Selecting data to copy and paste | 24 Apr 2007 23:26 GMT | 6 |
I have a macro that sorts data into the correct order, then I manually copy and paste into a different application. I would like to write code into the macro that copies the data after sorting, but the length of the data list is variable, i.e. sometimes it could be spread from A1 ...
|
| Alternatives to Excel VBA (Query Tables returning more than a million rows) | 24 Apr 2007 23:17 GMT | 2 |
I know how to develop VBA applications in Excel. I'm trying to accomplish a simple task: 1) let a user pick some values from a UserForm 2) plug those values into a SQL statement
|
| ComboBox Problems | 24 Apr 2007 23:08 GMT | 1 |
I would like the combo box to have a static set of values, but I don't know how to do it. I have tried to use rowsource, but the three cells I want are not together (D9,J9,D52), is there a way just to type in the values I want on the list? Any help would be greatly appreciated.
|
| What's wrong with my code? Thanks | 24 Apr 2007 22:40 GMT | 4 |
I'm using the following macro to format phone numbers from "1234567890" to "123-456-7890". While this works fine on single cells when I try it on a list it deletes the numbers and inserts the dashes "--". What is wrong with this? Thanks.
|
| Excel Prints the Page as a Tiny Little Square | 24 Apr 2007 22:23 GMT | 3 |
Anyone? Someone sent me an Excel spreadsheet. Half of the tabs are ok, but half of them print as a one-inch square floating somewhere on the page.
|
| relating 2 sheets | 24 Apr 2007 22:03 GMT | 2 |
I have two sheets where I have to drag data from the first sheet to the second one which plays the role of a report. I am not being abele to get the exact vlookup formula. to clear myself take this exapmle,
|
| Control box/Command buttons | 24 Apr 2007 22:02 GMT | 6 |
I understand how to make one but what i do not usderstand is where to put the code to make other stuff happen. Here is example. I made a Command Box and named it Random. I put it in F3 and it is set for a single click. Now what I want to do is get it to put a random number that ...
|
| Populate A Userform ComboBox | 24 Apr 2007 21:52 GMT | 2 |
I am trying to create a search program for a workbook I have been working on for sometime. I have created a userform and included a number of comboBoxes. I would like the form to function much like the conditinal formatting userform. I would like to have the first
|
| MACROS 2 | 24 Apr 2007 21:49 GMT | 1 |
Where can I find the STOP RECORDING TOOLBAR??
|
| MACROS | 24 Apr 2007 20:46 GMT | 2 |
I am NOT at all familiar nor cognizant of using macros (with VBE), etc. In fact, mI am not quite sure what a macro is...although I believe it solves the problems of repeat and monotonous work in EXCEL. Will someone please give me a simple instruction on installing a macro,
|
| what does target.offset(0,-1).select mean here? | 24 Apr 2007 20:38 GMT | 1 |
In a small area on my worksheet(A1 to A5), I want to achieve the checklist effect. That means if I double click one of the cell, if the whole area is empty(without "X"), then the clicked cell appeared "X", if there is already "X" in this area, then the doubleclick is ignored, if ...
|
| If Conditional formatting | 24 Apr 2007 20:34 GMT | 7 |
Following is my code, which is used more than once in the Sub. Range("F88").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=E88<1"
|