Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
What meaning18 Mar 2008 19:09 GMT1
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 Macro18 Mar 2008 19:07 GMT3
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 listboxs18 Mar 2008 18:56 GMT1
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 function18 Mar 2008 18:54 GMT3
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 Button18 Mar 2008 18:54 GMT2
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 Excel18 Mar 2008 18:41 GMT2
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 properties18 Mar 2008 18:31 GMT2
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 input18 Mar 2008 18:25 GMT8
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 control18 Mar 2008 18:25 GMT3
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 Macro18 Mar 2008 17:48 GMT5
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 worksheets18 Mar 2008 17:43 GMT5
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 set18 Mar 2008 17:34 GMT2
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 cell18 Mar 2008 16:56 GMT2
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 / Or18 Mar 2008 16:19 GMT2
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 month18 Mar 2008 16:18 GMT9
I have created a worksheet that we need to copy and label January through
December, is tere a way to do this automatically?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.