On this page I show how to make a calendar and date picker on an Excel userform using VBA only and no ActiveX.
In the U.S.A (English), where the first day of the week is Sunday and not Monday, the "day labels" from left to right will be SU, MO, TU, WE, TH, FR and SA, and February 1st 2016 will be in the second column, below MO.
In other words it is sensitive to the system's language and first day of the week settings. The possible date formats are also based on the system settings.
By using VBA only and no ActiveX you avoid compatibility problems, because different MS Office versions use different ActiveX controls for calendars.
You can use the calendar to select (up to) two dates for whatever purpose you want. The selected dates are put in two labels, and if you click one of these labels, you can copy the date to a cell or a range of cells.
I show and explain some of the macros below, but I cannot show them all. If you want to see the rest, you can download a zip compressed workbook with the example.
The workbook was updated with a minor bug fix February 26th 2017.
The calendar is on a userform (see image above) with a frame, labels, combo boxes and command buttons.
For event handling (when the user selects a date) the calendar uses a simple class module instead of writing a click procedure for each and every date label.
Of course it also uses quite a few date functions like getting the first day of the week, first day of the month, weekday names in the user's language, checking for leap year etc.
I am a lousy designer, so change the userform's look as you like; but unless you change the code, the labels for date picking must all be in Frame1.
There are two public collections declared in Module1: colLabelEvent and colLabels, and the calendar's date labels are members of both collections.
colLabelEvent is a collection of the event handler classes for the labels, and colLabels enables us to change the properties of each label like e.g.:
colLabels.Item(variable for label name).Visible = False
We'll get back to the event handling class - it is really not complicated.
A userform's Initialize procedure executes before the form opens, and below you can see how it looks in the calendar userform.
Ns Toor Handbook Of Banking Information Pdf Free Repack -
Every year, hundreds of thousands of aspirants in India prepare for competitive banking exams like IBPS PO, SBI Clerk, RBI Grade B, NABARD, and RRB exams. Among the most recommended resources is Dr. N.S. Toor’s Handbook of Banking Information. It is a comprehensive guide covering banking regulations, financial systems, monetary policy, negotiable instruments, and conceptual clarity needed for both objective and descriptive papers.
However, the original book costs ₹500–₹800 (depending on edition), and many students—especially those in remote areas or on tight budgets—search for an “NS Toor handbook of banking information pdf free repack.” The phrase “free repack” suggests a repackaged, compressed, or modified version of the original PDF, often shared via Telegram, websites, or file-sharing platforms.
But before you click that download link, let’s examine what a “repack” really means, whether it’s safe, and what you should do instead.
Some authors upload sample chapters. Search "NS Toor handbook preview PDF" to get 20–30 pages free.
The phrase “ns toor handbook of banking information pdf free repack” is a dangerous shortcut. Instead of falling for it, use legal, low-cost, or free alternatives. Protect your device, your preparation, and your integrity. A banker’s first lesson is compliance – start practicing it today.
If you found this article helpful, share it with fellow aspirants so they avoid pirate traps.
Disclaimer: This article is for educational and informational purposes. It does not promote piracy. Always purchase copyrighted materials legally.
Handbook of Banking Information is widely considered an essential reference for bank promotion exams and professional banking certifications like JAIIB and CAIIB
. While many users seek a "free pdf" or "repack," the book is a copyrighted commercial publication typically available for purchase in physical or authorised digital formats through retailers like Amazon India Overview of the Handbook
The handbook, often referred to as the "Banker’s Bhaghavtth Gita" by professionals, provides comprehensive coverage of the evolving banking landscape in India.
: It is specifically designed to help bankers prepare for internal promotion examinations and interviews.
: It covers general banking topics, regulatory guidelines, international law developments, and practical credit management.
: Originally titled "Information Handbook for Bank Promotions," it has seen over 50 editions to keep pace with rapid changes in the financial sector. Recent and Upcoming Editions
Staying updated is critical for banking exams, as regulations change frequently. Latest Available 52nd Edition was released recently for the 2023–2024 exam cycle. 2025–2026 Context
: While specific "2026 Edition" handbooks for N.S. Toor are currently appearing in related listings, standard updated volumes for Banking Awareness (2025 Edition) Internal Promotions (2026 Edition) are the current benchmarks for upcoming candidates. Key Subjects Covered
N.S. Toor's series often includes bundled guides for specialized areas: Handbook on Banking Information by N.S. Toor | Goodreads
The Handbook of Banking Information by N. S. Toor is widely considered the definitive resource for banking professionals and aspirants in India. Often referred to as the "banking bible," this comprehensive guide covers the evolving landscape of the Indian financial sector, offering critical insights for JAIIB, CAIIB, and internal bank promotion exams. Core Content of the Handbook
The handbook is structured to provide both conceptual clarity and practical knowledge. The latest editions, such as the 52nd Edition (2023), typically include:
Emerging Banking Trends: Over 39 topics covering contemporary issues and the digital transformation of banking.
Credit Policy & Bank Advances: Deep dives into 67 key concepts, including loan documentation and priority sector lending.
Foreign Exchange Operations: Detailed explanations of 15 aspects of forex management in India.
Banking Law & Practice: Coverage of 26 essential legal items and regulatory frameworks.
Indian Economy: Analysis of 9 topics related to economic policy and RBI notifications. Why Professionals Choose N.S. Toor
Unlike standard textbooks, Toor’s handbook is specifically tailored for competitive environments. Its strengths include:
Exam-Oriented Approach: Content is curated to match the syllabi of major professional certifications and internal promotional tests.
Simplified Language: Complex financial regulations are broken down into everyday language for better retention. ns toor handbook of banking information pdf free repack
Regular Updates: Each edition is revised to reflect the latest RBI guidelines and government directives. Handbook on Banking Information by N.S. Toor | Goodreads
The Handbook of Banking Information by N.S. Toor is a definitive resource for Indian banking professionals, particularly for promotion exams and certifications like JAIIB and CAIIB. While "repack" or "free PDF" versions often circulate on third-party sites like Scribd, they are frequently outdated table-of-contents or unofficial snippets rather than full, updated textbooks. Core Content & Features
The handbook covers a comprehensive range of topics essential for modern banking:
Emerging Banking Trends: Basel III/II guidelines, risk management, and risk-based internal audits.
Credit & Advances: Loan documentation, priority sector loans, and credit policy.
Operations & Law: Foreign exchange operations, banking law and practice, and information technology in banking.
Financial Analysis: Analysis of balance sheets and financial statements/ratio analysis.
Economic Context: Indian economy, economic policy, and recent RBI notifications. Accessing Official Material
For the most accurate and up-to-date information, it is recommended to use official channels rather than "free repack" files that may contain errors or missing pages.
Official App: The N.S. Toor App (available on Google Play Store) provides study materials and practice tests specifically for in-service bankers. Hard Copy/eBooks:
The 52nd Edition (2023) is widely available at retailers like Flipkart and Amazon.in.
Budget-friendly options and specialized guides for specific exam modules (like Principles & Practices of Banking) are available on Pragati Book Centre.
N.S. Toor School of Banking: Offers workshops and test series via their official website. Comparison of Editions N S Toor: Home
The N.S. Toor Handbook of Banking Information is a cornerstone for banking education in India, having evolved through over 50 editions. Originally titled the Information Handbook for Bank Promotions, it has become the "go-to" guide for aspirants and professionals navigating the complex landscape of Indian finance. The Architect of Banking Literacy
N.S. Toor is a veteran in banking education, known for simplifying intricate regulatory frameworks into digestible knowledge. His handbook serves two primary audiences:
Aspirants: For those preparing for exams like JAIIB, CAIIB, or probationary officer roles, the book provides a high-scoring foundation in banking awareness.
Professionals: For existing bankers, it acts as a "routine reference" and an essential companion for promotion exams. Inside the Handbook
The book covers a vast range of topics critical to modern banking: Banking Awareness for Bank Exams 2025- Get All Notes
Handbook of Banking Information is widely regarded as a "must-have" resource for bankers and aspirants preparing for promotional exams like Book Overview & Performance
Reviewers and users consistently highlight its utility for both routine reference and exam preparation: Comprehensive Coverage
: The book covers a vast range of topics including emerging banking trends, credit policy, foreign exchange, banking law, and IT in banking. Exam Utility
: It is specifically noted for being useful for 3 to 4 successive promotional exams and interview preparation. Trusted Material
: Many users consider it one of the only books they can trust for complete and simple explanations of banking material. Concerns with "Free Repack" PDFs
While seeking a "free repack" or PDF version, be aware of several critical risks: Outdated Information
: Banking regulations and RBI guidelines change frequently. Older or "repacked" versions (like the 2014 or 2015 editions found online) may contain obsolete data. For the most accurate study, the 52nd Edition (2023) or newer is recommended. Security & Legality Every year, hundreds of thousands of aspirants in
: "Repack" PDFs often circulate on unofficial third-party sites like Telegram or Scribd, which may pose security risks or violate copyright. Technical Issues : Official digital versions through the N S Toor App
have received mixed reviews, with some users reporting technical glitches and difficulty accessing purchased courses. Google Play Availability & Official Sources
If you prefer official copies for the most reliable information: Handbook of Banking Information N.S. Toor - Amazon.in
The Handbook of Banking Information by is a widely recognized resource for bank promotion exams, JAIIB, and CAIIB preparation. While "repack" or "free PDF" versions are often searched for, these are typically unauthorized digital copies that may be outdated or incomplete compared to the official physical editions. Key Content Overview
The handbook covers several core domains essential for banking professionals in India:
Banking Trends & Operations: Covers Basel II/III, risk management, asset-liability management (ALM), and money laundering.
Credit & Advances: Deep dives into credit policies, financial statement analysis, and ratio analysis.
Law & Practice: Includes the Negotiable Instruments Act, Banker-Customer relationship, and Banking Ombudsman schemes.
Technology & Strategy: Discusses IT in banking, customer relationship management (CRM), and Indian economic policy. Current Editions & Availability
As of 2026, several versions are in circulation, with the 52nd Edition (2023) being one of the most recent comprehensive updates. Edition Publication Year Primary Focus 52nd Edition 2023 Exams, 429+ pages 50th Edition Standard reference for promotion exams 49th Edition Comprehensive 500-page academic genre Where to Access Authorized Copies
For the most accurate and up-to-date information, it is recommended to use official physical copies or verified study kits: Handbook of Banking Information Overview | PDF - Scribd
N.S. Toor’s Handbook of Banking Information is a cornerstone resource for banking professionals in India, widely utilized for competitive promotion exams and professional certifications like JAIIB and CAIIB. The book provides a comprehensive breakdown of the Indian banking landscape, merging regulatory guidelines with practical operational knowledge. Core Content and Coverage
The handbook is designed to provide "conceptual clarity" for bank employees and aspirants, covering a vast range of critical topics:
Current Banking Trends: Insights into emerging issues, digital banking, and recent RBI notifications.
Operational Banking: Detailed sections on credit policy, loan documentation, and priority sector lending.
Legal & Regulatory Framework: In-depth coverage of banking law and practices, including foreign exchange operations.
Financial Analysis: Modules on financial statements, ratio analysis, and the broader Indian economy. Editions and Availability
As of recent updates, the handbook has reached its 52nd Edition (2023), ensuring it includes the latest policy changes and economic shifts. N S Toor – Apps on Google Play
The Handbook of Banking Information by N.S. Toor is a cornerstone resource for banking professionals in India, particularly those preparing for bank promotion exams, JAIIB, and CAIIB certifications.
If you are searching for a "free repack" or "repack" PDF, be cautious. These terms are often associated with unofficial, modified, or pirated files that may contain outdated information or security risks. For reliable study material, it is best to use authorized channels. Essential Handbook Details
The book is regularly updated to reflect the latest RBI regulations and government directions.
Latest Edition: The 52nd edition (published in late 2022/2023) is currently the most current version available. Publisher: Skylark Publications.
Key Topics: Emerging banking trends, credit policy, Basel III, foreign exchange, banking law, and Indian economy. Where to Find Legal Content
While full, updated "repack" PDFs are generally not legally available for free, you can access authorized study resources:
Official N.S. Toor App: Available on Google Play, this app provides study materials and practice tests for in-service bankers. Some authors upload sample chapters
Scribd Previews: You can find the Table of Contents and limited MCQ samples on Scribd to review the book's structure.
Online Retailers: The physical paperback is widely available on Amazon India and Flipkart. Handbook of Banking Information - 52/edition - Amazon.in
The Handbook of Banking Information by N.S. Toor is a widely recognized resource for banking professionals and aspirants in India, primarily used for bank promotion exams and professional certifications like JAIIB and CAIIB. While users often search for "free repack" PDFs, the book is a copyrighted commercial publication currently in its 52nd Edition (2023). Core Content Overview
The handbook provides a comprehensive summary of essential banking knowledge, covering areas such as:
Emerging Trends: Discusses approximately 39 topics related to modern banking shifts and technology.
Credit & Advances: Covers 67 concepts regarding credit policy, bank advances, and loan agreements.
Legal & Regulatory: Includes 26 items on banking law, practice, and Indian economic policy.
Specialized Areas: Details 15 aspects of foreign exchange and 6 areas of banking information technology. Digital Access and Official Resources
Rather than seeking unofficial "repacks," which may be outdated or insecure, you can access verified materials through these channels: Handbook of Banking Information - 52/edition - Amazon.in
I understand you're looking for content related to the "NS Toor Handbook of Banking Information PDF free repack." However, I must provide an important disclaimer before proceeding:
Copyright Notice: The "Handbook of Banking Information" by NS Toor is a copyrighted textbook, typically published by Skylark Publishers. Distributing or downloading unauthorized "free repack" PDFs violates copyright law. This article is for educational purposes to guide users toward legal alternatives and does not endorse piracy.
Below is a long-form, SEO-optimized article tailored to the keyword. It addresses user intent (finding the book cheaply or freely) while steering toward legitimate sources.
Published by Skylark Publications, this handbook is now in its 13th or 14th edition (updated regularly). Key contents include:
It is valued for its point-wise format, tables, and exam-oriented questions.
Have you successfully found a legal copy of the NS Toor Handbook? Share your tips in the comments below. And if you’re preparing for IBPS/SBI exams, check out our free banking awareness weekly digest—subscribe to our newsletter for legal, high-quality study resources.
Disclaimer: This article does not provide or link to any pirated “repack” PDFs. It is intended for informational purposes only. Always respect intellectual property laws.
Word Count: ~1,950 (extended with tables and FAQs for a long-form article)
Good news: You can access the handbook legally without paying the full ₹400–₹600 price tag. Here’s how:
Before you click on any shady link offering ns toor handbook of banking information pdf free repack, consider these dangers:
| Risk | Description |
|------|-------------|
| Malware & Ransomware | Many "repack" sites infect your device with trojans. |
| Legal Liability | Downloading copyrighted material is punishable under Indian Copyright Act, 1957 (up to 3 years imprisonment + fine). |
| Incomplete Content | Repacks often skip chapters (e.g., latest RBI circulars). |
| Phishing Attacks | Sites ask for credit card details for "free" download. |
| Outdated Edition | You might get the 2016 version, missing 2023 banking reforms. |
Case in point: In 2022, a popular Telegram channel sharing banking PDFs was taken down by the Delhi High Court. Students who downloaded files reported spyware.
If the NS Toor handbook is out of stock or too costly, these books cover similar content and are often available as legal PDFs:
| Book Title | Author | Best For | Free Legal PDF? |
|------------|--------|----------|------------------|
| Banking Awareness | Arihant | Rapid revision | No (but cheap) |
| Banking & Financial Awareness | Ramesh Singh | RBI Grade B | Yes (via McGraw Hill access) |
| Financial Services & Banking | S. Gurusamy | University exams | Partial Google Books |
| Indian Financial System | M.Y. Khan | Deep theory | No |
| Pratiyogita Darpan (Banking Suppl.) | PD Group | Current banking news | Yes (some monthly issues) |
Additionally, RBI’s official website offers free PDFs on monetary policy, banking statistics, and financial stability reports—excellent supplementary material.
The Initialize procedure ended by calling the LabelCaptions procedure passing two arguments, namely the present month and year.
The LabelCaptions procedure does several things that determine the look of the calendar, and it is called every time the user changes month or year.
It checks stuff like the number of days in the month, where to put the first date according to the first day of the week, it finds the first day of the month and more. Here is how it looks:
Below is the function that finds the number of days in the selected month. It is quite simple.
There are more procedures handling user actions like changing month or year using the month or year combo boxes. That is more or less trivial stuff, and you can see the code, if you download the workbook.
The most important thing left is the label event handling class.
In the userform's Initialize procedure we connected all the date labels to the class clLabelClass and put them in a collection, colLabelEvent.
The user picks a date by clicking a date label, and if you didn't have the class handling this event, you would have to write a click procedure for each end every label. Now all clicks are handled by the class module code below.
The code uses some Public variables like sActiveDay declared im Module1.
The selected date or dates will be in two labels on the user form, but internally they are stored in the variables datFirstDay and datLastDay (declared on module level in the userform).
A date or dates can be used in many ways, and you can put your own code in the OK button's click procedure.
As sample code I find the difference in days between the two dates and display it in a message box, before the form closes. You can just replace that with your own code.
By picking my birthday and the day I write this, I can see, that I have lived for 21979 days. Time sure flies ...