Sample VB programs for Starting VB

[sumit.dutt]

Hi,

Need your help in generating these programs in VB as i am a beginer and do not know how to start VB, These programs will help me in getting started with VB..

Q1: Create a program that accepts input from the user (a birth date) and calculates the persons age. Your program should display the calculation three ways: exact age (years months and days {eg: You are 21 years, 2 months and 16 days old, today}), just years, total days.


Q2: Develop a VB project that maintains a list of book categories. Use a ComboBox control (Simple combo


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[stanleydgromjr]

sumit.dutt,

Welcome to the ExcelFox forum.

We are not here to do your work (or your homework) for you. Before posting a question or request for help, please put in the time and effort on the problem yourself.

Once you have completed your work on each question, post it here, and, we would be happy to review it, make suggestions, update your code, and/or show you another way to solve the question.

But, you must put the effort in first.

Need your help in generating these programs in VB as i am a beginer and do not know how to start VB, These programs will help me in getting started with VB..

Training / Books / Sites

MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
MrExcel's Products: Books, CDs, Podcasts - MrExcel Message Board

How to Learn to Write Macros
http://articles.excelyogi.com/playin...ba/2008/10/27/

How to use the macro recorder
Excel Yogi’s

Click here and scroll down to Getting Started with VBA.
DataPig Technologies

If you are serious about learning VBA try
Macros Made Easy for Microsoft Excel

Excel Tutorials and Tips - VBA - macros - training
Excel Tutorial | Excel Tips | Excel Articles

See David McRitchie's site if you just started with VBA
Getting Started with Macros and User Defined Functions

What is a Visual Basic Module?
What Is A VBA Module?

Debra Dalgleish has some notes how to implement macros here:
Excel VBA -- Adding Code to a Workbook

David McRitchie has an intro to macros:
Getting Started with Macros and User Defined Functions

Ron de Bruin's intro to macros:
Where do I paste the code that I want to use in my workbook

Creating custom functions
Creating custom functions - Excel - Office.com

Writing Your First VBA Function in Excel
Writing Your First VBA Function in Excel

Where to paste code in VBE VBA
Introducing the Excel VBA Editor
Where to paste code in the Excel VBA Editor - Norton Safe Search

VBA for Excel (Macros)
Excel Macros (VBA) Tutorial

VBA Lesson 11: VBA Code General Tips and General Vocabulary
VBA for Excel macros language

Excel VBA -- Adding Code to a Workbook
Excel VBA -- Adding Code to a Workbook

Learning about EXCEL macros
Getting Started with Macros and User Defined Functions
Microsoft Excel Links / Microsoft Excel Tips / Excel Tutorial / Excel Spreadsheet Help / Excel Tip .com

(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0
http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

Learn to debug:
Debugging VBA

Excel Tutorials / Video Tutorials - Functions
Excel VLookup Function and VLookup Example

XL-CENTRAL.COM: Your Quick Reference to Microsoft Excel Solutions

DataPig Technologies

Cascading queries

http://www.tushar-mehta.com/excel/ne...ing_dropdowns/

Excel VLOOKUP Function and VLOOKUP Example
Excel VLookup Function and VLookup Example

INDEX MATCH - Excel Index Function and Excel Match Function
Excel VLookup Function and VLookup Example

Excel Data Validation -- Dependent Lists
Excel Data Validation List from Another Workbook
Excel Data Validation Tips and Quirks

Excel Data Validation - Add New Items
Excel Data Validation - Add New Items

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
Programming In The VBA Editor

Locating files containing VBA
Searching Files in Subfolders for VBA code string:
http://www.dailydoseofexcel.com/arch...a-code-string/

Re: Excel XP VBA code to search all macro code in Excel module for specific search string criteria

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)
by John Walkenbach

VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…
Learn Excel 97 through 2007 from Mr Excel - Revised and Expanded Second Edition

Professional Excel Development
by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)

Excel 2002 VBA: Programmers Reference
by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)

VB & VBA in a Nutshell: The Language
(http://www.amazon.co.uk/VB-VBA-Nutsh...4671189&sr=1-2)

Writing Excel Macros with VBA
(http://www.amazon.co.uk/Writing-Exce...4671189&sr=1-3)

User Form Creation
Create an Excel UserForm

DonkeyOte: My Recommended Reading
Volatility
Volatile Excel Functions -Decision Models

Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Arrays
Excel: Introduction to Array Formulas - Xtreme Visual Basic Talk

Pivot Intro
Using Pivot Tables and Pivot Charts in Microsoft Excel

Sync Pivot Tables
http://www.mrexcel.com/forum/showthr...g+pivot+tables
Check out rorya's post at the very bottom of this link. It should do the trick:
Experts Exchange - Your Technology Questions Answered
Multiple pivot tables 1 filter to control all
http://www.excelforum.com/excel-prog...ntrol-all.html

Email from XL - VBA
Example Code for sending mail from Excel

Outlook VBA
Writing VBA code for Microsoft Outlook

Function Dictionary
http://www.xlfdic.com/

Function Translations
Excel 2007 function name translations - Dictionary Chart Front Page

Dynamic Named Ranges
Excel Names -- Excel Named Ranges

How to create Excel Dashboards
Excel Dashboard Templates
Excel Dashboards - Templates, Tutorials, Downloads and Examples | Chandoo.org - Learn Microsoft Excel Online
Excel Dashboards - Templates, Tutorials, Downloads and Examples | Chandoo.org - Learn Microsoft Excel Online
Free Microsoft Excel Dashboard Widgets to Download

Excel Dashboard / Scorecard Ebook
Excel Dashboards and Scorecards Ebook | How to Create Dashboards in Excel

Templates
CPearson.com Topic Index
Excel Template - Golf Scores

Mike Alexander from Data Pig Technologies
Excel 2007 Dashboards & Reports For Dummies

Date & Time stamping:
McGimpsey & Associates : Excel : Time and date stamps

Get Formula / Formats thru custom functions:
Show FORMULA or FORMAT of another cell

A nice informative MS article "Improving Performance in Excel 2007"
Improving Performance in Excel 2007

Progress Meters
AJP Excel Information - Progress meters
Excel


Have a great day,
Stan

[sumit.dutt]

Thanks a lot admin .. I have to help a someone .. which i have already done using MSDN now.. i whould have appreciated this post if i have received on the day or two after i have posted this thread... nevermind .. let me know in case you ever need any help in Oracle ,BI or DWH domain ..

Thanks, but no thanks for your post ..