| Thread | Last Post | Replies |
|
| Conditional Format assistance? | 18 Apr 2008 16:19 GMT | 4 |
Condition formatting is getting the best of me at the moment. I need to set up a Conditional Format that has 3 rules. 1. if the number in the cell is >= 85% then the background of the cell needs to be green
|
| execute a make table query in an access database | 18 Apr 2008 16:07 GMT | 1 |
The basic idea: I need to run an existing make table query in a database without the user's intervention. I have tried some code I have found online but none work (thus far).
|
| Multiple Conditional Formatting in VB | 18 Apr 2008 16:01 GMT | 7 |
I need to add a set of formats to a column but based on IF statements. For example, I have column A (Date Raised) and column I (Date Acknowledged), I want to be able to colour the cells based on what date was added to column I e.g:
|
| Show Image When File Opened | 18 Apr 2008 15:55 GMT | 1 |
How do I show a logo image for a few seconds each time a file is opened? Cheers Tony
|
| Problem with formating | 18 Apr 2008 15:35 GMT | 7 |
I have an array that contains string values. When I put one of these values into my spreadsheet it changes to Scientific. Dim DataRow(12) DataRow(9)="201E-13" ' for this example
|
| VBA code to run & wait for cmd line interface application | 18 Apr 2008 15:21 GMT | 1 |
I want to get started with the shell command to run my process below under 1 VBA subroutine. I've just started looking at methods to wait for the external application to complete. Any pointers would be very welcome. Thanks
|
| Macro | 18 Apr 2008 15:19 GMT | 10 |
I receive, daily, a spreadsheet with a lot of data. In one column, all the cells contain numbers and text and I want to change this to reflect the numbers only (which must represent values). The text portion is always the same in all of the cells. I have recorded a macro which ...
|
| Range.Find gets slow | 18 Apr 2008 15:05 GMT | 19 |
After I use Range.Find method programmatically, the standard search on sheets dramatically slows down. What could be the reason and how can this side effect be taken out? Thanks! After I use Range.Find method programmatically, star=ndard it searches
|
| enable macros without them running | 18 Apr 2008 14:49 GMT | 2 |
In excel 03 I just held down SHIFT while clicking ok on the enable macro option, but I have upgraded to excel 07 and this doesnt seem to work. I need to run macros while I am editting the workbook. How can I do this with excel 07.
|
| Variable not set | 18 Apr 2008 13:57 GMT | 4 |
I have this macro running from a commandbutton in sheet2, it gets a concatenated string and look it up in sheet24 once found retrieves datum from sheet24 and shows it in an userform I'm getting the variable/block not set error for rFound, cFound is working
|
| Shell or shellexecute | 18 Apr 2008 13:53 GMT | 1 |
I want to open A.dwg and B.dwg files in different moment from VBA excel using Shell. I use the following line and it works right: RetVal = Shell(GstrPercorsoCad + " " + GstrFileAorB, vbMaximizedFocus)
|
| MATCH function, with variable lookup_array | 18 Apr 2008 13:50 GMT | 12 |
Is there a way to select a variable lookup_array. This is the situation. Input: Dia: 130 (e.g.)
|
| Hyperlink Help | 18 Apr 2008 13:45 GMT | 1 |
I'm trying to create a hyperlink to open another workbook and so far i have got this code: Sub Hyperlink() ActiveWorkbook.FollowHyperlink
|
| Limit an GoTo Function command | 18 Apr 2008 13:44 GMT | 1 |
I am writing VB code in Excel to reformat a number of Excel spreadsheets. There's a section of the code where I have inserted an "On error GoTo Function" command to skip past a section of code if certain requirements are not met. However, if my code errors at any other place than ...
|
| OLEObjects: Adding jpg Object | 18 Apr 2008 13:44 GMT | 5 |
Is there a way to add a jpg object on a cell? I'm using Paint.Picture but the image is in bmp. We are trying to minimize the overall size of the excel file. We have been using word document before, but we jpg is a much smaller file.
|