| Thread | Last Post | Replies |
|
| Selecting first empty row in column | 29 Mar 2006 16:02 GMT | 2 |
Using macros... I'm converting one file to another by copying and pasting data. I wan to paste the second set, and every subsequent set, below the data pasted before. The problem is I’m not sure how to select the firs
|
| Linking checkboxes between userforms | 29 Mar 2006 16:01 GMT | 2 |
Is there a way to link checkboxes between 2 different user forms (say ckbCoast is in frmLocal and ckbSFR is in frmInfo)? Perhaps there's Hide Me function that would keep one user form open, just not shown on the screen giving the next form the
|
| Finding Range of one Workheet used in another | 29 Mar 2006 16:00 GMT | 6 |
I need to find the last row of worksheet A and use this as range fo worksheet B. Workshhet A can change row count so I need B to canhang as well Example:
|
| Debug suggestions? | 29 Mar 2006 15:55 GMT | 4 |
I've created a workbook with 2 userforms and my macros; it all works well on my PC and several others. For the few folks who have had problems, they have been able to email me screenshots so that I know where the errors are occuring and can fix them. Everyone is using either Win2000 ...
|
| Using vba to generate xy scatter plots in excel | 29 Mar 2006 15:42 GMT | 3 |
Hello. I was trying to use vba to generate some xy scatter plots. It seems like a simple task, but I haven't been able to find much on it. Anyways, I have one column of data which I want to be the x-values, and another column of y-values. I want to set the y-axis to a ...
|
| Delete row if no date exist | 29 Mar 2006 15:25 GMT | 7 |
I have a macro that combines multiple sheets into one. I want to add to the macro that once the master file is compiled, delete any row in column "A" that doesn't have date Basically
|
| Copy File into Worksheet | 29 Mar 2006 15:21 GMT | 1 |
Hi. I need to copy a xls file into an existing worksheet. For example, am trying to copy the cell contents of test.xls from A4 to Z9 into worksheet that I already have called, "TestSheet". How would I go abou this?
|
| Module Names11 | 29 Mar 2006 15:13 GMT | 3 |
Hi - I have a pile of modules in my Excel workbook. I was copying some others from another workbook. So now I have some modules, not all, being named "Module2.All" rather than just "All". I can't find any rename option for the modules and of course any procedure that calls ...
|
| Move cursor to textbox in a userform | 29 Mar 2006 14:55 GMT | 5 |
Hi, I would like to check (on Exit) a value entered in a textbox with certain cell. That's not the problem, but I would like to find a metho how to move the cursor to the wrong entered value (so: back to tha
|
| How do I do a VBA comparison to a financial value (i.e. $10000) | 29 Mar 2006 14:50 GMT | 4 |
It's been a while since I've used VBA. How do I do a comparison with a financial value? I have the following, but no matter what the value of the cell this puts a 1 into the active cell.
|
| Can We Do It In Excel ? | 29 Mar 2006 14:40 GMT | 1 |
I have a template with some columns as attachment Question is: I would like to have a field, When people type in valuethen Enter, the program will automatically filter rows whic column (Applicable Service) is not typed value.
|
| Running code by clicking on a hyperlink cell | 29 Mar 2006 14:27 GMT | 3 |
I have a list of published reports in a worksheet, some of which hav hyperlinks to their location in Clarity (browser based projec management system) and some of which have empty hyperlinks (with given title)
|
| Advice on simple mod Req | 29 Mar 2006 14:00 GMT | 3 |
Hi all, I obtained this code after doing some research but I am not quite there yet. Would appreciate some ideas on how I can mod this code to populate columns "A to F" only on the "Order" sheet. Thanks,
|
| do while, "and function" | 29 Mar 2006 13:51 GMT | 2 |
Hello, I have a problem. In excel macro I have to use a "do while loop". I have two conditions to pass the loop. I made a code as below, d1=2
|
| Calculating dates based on the current date | 29 Mar 2006 13:42 GMT | 1 |
I have four textboxes on a form for a user to enter four dates. The four dates are: 1.) Beginning date of the current period. 2.) Ending date of the current period.
|