General

Excel VBA 'Help'
Up till yesterday the VBA Help utility was available while in the Editor. Now, on all three, of my computers' "'Help" is no longer there except for the option to get on-line help. Re-installing (Repair) did not fix the problem. Any suggestions? Thanks ... 22 Apr 2010 20:51

Pivot Table Change to US Date Format - Why?
Hi, I have a set of pivot tables which are being updated by cell the date in cell B1 using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields("Invoice Month").CurrentPage = ActiveSheet.Range("B1").Value At last this is working :) However... the dates are being inserted into the pivot... 26 Apr 2010 09:10

How do I find duplicate entries in a column in an Excel worksh
I know how to find duplicated records, but my problem is that I need to know where does the value is repeated. Home my ASCII art illustrates what I need. A B C 1 - a 2x - A4 2 - b 1x - A6 3 - c 1x - 0 4 - a 2x - A1 5 - d 1x - 0 6 - b 2x - A2 7 - e 1x - 0 A show the values B show how many ti... 22 Apr 2010 16:37

Time
I have time (mm:ss) in Column D. How do I count the number of times that the time is less than 10 minutes. Thanks, -- Howard ... 22 Apr 2010 20:51

WordWrap a TextBox on a UserForm
Hello, I have placed a textbox on a userform that could have a multiple lines of text entered into it. I have selected True for the WordWrap property but it still doesn't wrap. Also, I have made sure that the ControlSource (linked cell) is set to WordWrap as well. Any suggestions? Thanks David ... 22 Apr 2010 16:37

How do I get rid of the cross (white) in excel
I can't seem to close the white cross that highlights my page if I move it it keeps scrolling through the workbook I am not sure how it even came on to the page it was not there when I left my computer yesterday ... 22 Apr 2010 15:34

Excel development tools?
Hi, I want to develop some tools at work for Excel using Visual Basic. The goal is to make an exe file which will prompt the user for data input files and create spreadsheets. What tools do I need? Do I need to install Visual Studio Express and develop the VB code? Thank you in advance for any help. NJ ... 22 Apr 2010 16:37

how do i set up format for employee attendance monthly
i need a format of employees attendance which is how many sick days use, how much absent days, how much vacation used and how many medical leave brought in, and every month end a calculation and a percentage at the end of the format. ... 22 Apr 2010 18:42

Custom Formatting (# x 1000)
I want numbers to show up without the 1000's, but have the real numbers entered... I have some references to build on, but when I try to modify them to my need, I get an undesired result. What I want: -$100,000 would show as $(100) $100,000 would show as $100 What I have that works: $#,###, truncates positiv... 22 Apr 2010 16:37

Searching Post?
Excel2003 ... When searching post for "Kha" I do not see all my post returned .... & today I saw nothing for 2010??? Looking for guidance ... Thanks ... Kha (tough day today) Note: I think searched post should be returned sorted in descending order by date. ... 22 Apr 2010 18:42