| Thread | Last Post | Replies |
|
| What meaning | 18 Mar 2008 19:09 GMT | 1 |
I find this code ,who can translate for me? WM_MOUSEWHEEL fwKeys = LOWORD(wParam); /* key flags */ zDelta = (short) HIWORD(wParam);
|
| Can a Macro Run Another Macro | 18 Mar 2008 19:07 GMT | 3 |
I would like to know if a Macro can run another Macro - sort of a "Master Macro". The 5 macro's I have now are titled "CopyCell1", "CopyCell2", "CopyCell3, "CopyCell4 and "DeleteRowifZeroInA.
|
| which text be selects in VBA listboxs | 18 Mar 2008 18:56 GMT | 1 |
If ListBox2.Index = "2" Then Sheet3.Cells(3, 2) = TextBox1.Text Sheet3.Cells(4, 2) = "φ" & TextBox2.Text Sheet3.Cells(5, 2) = "NHC-7"
|
| help with Count function | 18 Mar 2008 18:54 GMT | 3 |
I have a file that has 20 sheets. every sheet has a populated cells. I would like to write a formula that counts the occurance of a cetrtain value on all the sheets without having to write it on every sheet. the following works per sheet only:
|
| Remove Forms Command Button | 18 Mar 2008 18:54 GMT | 2 |
Is there a way to totally remove a forms toolbox command button from a spreadsheet with VBA?
 Signature Thanks for your help.
|
| VB Code to Convert Rows into Columns in Excel | 18 Mar 2008 18:41 GMT | 2 |
I am trying to write a VB module in Excel that converts rows into columns. The data is distributed across 10-50 rows instead, I'd like to see 10-50 columns. This is the code that I used but doesn't seem to be working for me:
|
| Listing properties | 18 Mar 2008 18:31 GMT | 2 |
I am looking for something to help with my documentation that I can use to cycle through the controls on a User Form and list the properties of that control. When I read about Properties collection in Help, it appears that only
|
| Selection based on partial input | 18 Mar 2008 18:25 GMT | 8 |
Hi to all, In an Excel workbook, sheet1 has a list of the customer names : col1=idx and col2=name I need to build up a user form with
|
| Task option control | 18 Mar 2008 18:25 GMT | 3 |
I have the following code that work somewhat okay when I create a new Task record. Where I start running into problems is with the "With" Statement, Specifically the .Body = c.Offset(0, 2).Value
|
| Creating and Sharing a .xla VBA Macro | 18 Mar 2008 17:48 GMT | 5 |
I wrote a macro that will recognize eight different filenames and run the appropriate section of code when one of those eight (Excel) files are open. My goal is to make this macro available to a few other users by creating a .xla file and saving it on a folder on a network
|
| Loop and append to different worksheets | 18 Mar 2008 17:43 GMT | 5 |
I posted this previously but I have discovered a few more things about it and still need some help. I need help making this macro loop through more than one worksheet. And I need to make sure that the information appends correctly. Or I
|
| Finding all divisors of given number in a set | 18 Mar 2008 17:34 GMT | 2 |
is there an algorithm for this: In a column, say A, I have some 150 numbers; then I have one number N and I need to find all divisors of number N in column A and have them ''extracted' to a list, or marked, or whatever. Is there a piece of code? Thank you!
|
| name of cell | 18 Mar 2008 16:56 GMT | 2 |
Hi to all. I need to have a static name of cell. I mean: if I name cellA3 "dday", after a sort, this cell has new addres (ex A5), but the name "dday" remains to address A3.
|
| For Loop - If / Or | 18 Mar 2008 16:19 GMT | 2 |
I have created a loop, which has an or in the if argument For i = 2 To FinalRow If DATEDIFF("d", Cells(i, 6), Now) < 8 Or DATEDIFF("d", Cells(i, 6), Now) = "" Then
|
| One for every month | 18 Mar 2008 16:18 GMT | 9 |
I have created a worksheet that we need to copy and label January through December, is tere a way to do this automatically?
|