You are here:
Worked with the program for many years - provided assistance on MS Excel Newsgroups since 1997. Have received the Microsoft MVP award annually since 1999. I don't answer questions on using Excel in a browser Since I have no way to test this. Prefer not to answer charting questions. I consider myself to be particularly knowledgeable about using VBA internal to Excel but have no problems with formulas and pivot tables either.
Have Used Excel for 15 - 20 years. Answered in excess of 70,000 Excel related questions in MS Excel newsgroups. Unless obvious, please specify whether you want a worksheet function or macro/VBA solution.
BS General Engineering (concentration in Industrial Engineering) MS Operations Research Systems Analysis
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Ryan | 11/07/09 | 10 | 10 | 10 | 10 | Thanks for the help! |
| Adnan | 11/07/09 | 10 | 10 | 10 | 10 | Dear Tom, it is working great. Actually ..... |
| Michael | 11/06/09 | 10 | 10 | 10 | 10 | Tom, many thanks for the speedy response ..... |
| Steven | 11/05/09 | 10 | 10 | 10 | 10 | Works great, many thanks this has been ..... |
| Steve | 11/05/09 | 10 | 10 | 10 | 10 | Other than the stray "END IF" above ..... |
I assume your dropdown is done using the List option from data validation. If so, you can react to a selection by using the worksheet change event. Right click on the sheet tab and select view code
Sian, Let's assume that column B can be used to determine which rows are blank - i.e. if a cell in column B is blank, then the row needs to be hidden. Assume that values in column B are constants and
IAN, Based on your stated sitation and needs, I would recommend making the stored value and the displayed value by altering your formula to use the round function Y5: =(C5/100)*G5 becomes
Nessie, I created a userform and with Textbox1 and a commandbutton. I then put this code in the commandbutton to illustrate Private Sub CommandButton1_Click() TextBox1.Value = "The dog is
Malcom, E2: 8.55 E3: 11.2 E4: =SUBSTITUTE(TEXT(SUBSTITUTE(TEXT(E3,"#.00"),".",":")-SUBSTITUTE(TEXT(E2,"#.00"),".",":"),"h:mm"),":",".")*1 produces 2.25 for me. Basically, use substitute
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.