98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivots
Pivots
Resolved · Low Priority · Version 2007
Wed 1 Apr 2009, 15:58Delegate Varuni said...
Varuni has attended:
Excel VBA Intro Intermediate course
Pivots
Is there code to stop people typing into drop down boxes - ie only able to pick whatever is in drop down rather than typing over data
Thu 9 Apr 2009, 09:53Trainer Stephen said...
RE: Pivots
Hi Varuni
Thank you for your question
Can you clarify the following for me please
Are you referring to a combo box on a form, or the page field in a pivot table
Thanks
Stephen
Thu 14 May 2009, 09:44Trainer Rich said...
RE: Pivots
Hi there,
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
Wed 20 May 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formula for last day of monthIn some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 |
