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 (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 (http://www.mrexcel.com/forum/forumdisplay.php?f=19)

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

How to use the macro recorder
Excel Yogi’s (http://articles.excelyogi.com/)

Click here and scroll down to Getting Started with VBA.
DataPig Technologies (http://www.datapigtechnologies.com/ExcelMain.htm)

If you are serious about learning VBA try
Macros Made Easy for Microsoft Excel (http://www.add-ins.com/vbhelp.htm)

Excel Tutorials and Tips - VBA - macros - training
Excel Tutorial | Excel Tips | Excel Articles (http://www.mrexcel.com/articles.shtml)

See David McRitchie's site if you just started with VBA
Getting Started with Macros and User Defined Functions (http://www.mvps.org/dmcritchie/excel/getstarted.htm)

What is a Visual Basic Module?
What Is A VBA Module? (http://www.emagenit.com/VBA%20Folder/what_is_a_vba_module.htm)

Debra Dalgleish has some notes how to implement macros here:
Excel VBA -- Adding Code to a Workbook (http://www.contextures.com/xlvba01.html)

David McRitchie has an intro to macros:
Getting Started with Macros and User Defined Functions (http://www.mvps.org/dmcritchie/excel/getstarted.htm)

Ron de Bruin's intro to macros:
Where do I paste the code that I want to use in my workbook (http://www.rondebruin.nl/code.htm)

Creating custom functions
Creating custom functions - Excel - Office.com (http://office.microsoft.com/en-us/excel/HA011117011033.aspx)

Writing Your First VBA Function in Excel
Writing Your First VBA Function in Excel (http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html)

Where to paste code in VBE VBA
Introducing the Excel VBA Editor
Where to paste code in the Excel VBA Editor - Norton Safe Search (http://www.ask.com/web?qsrc=2417&o=101881&l=dis&q=Where+to+paste+code+in+the+Excel+VBA+Editor)

VBA for Excel (Macros)
Excel Macros (VBA) Tutorial (http://www.excel-vba.com/excel-vba-contents.htm)

VBA Lesson 11: VBA Code General Tips and General Vocabulary
VBA for Excel macros language (http://www.excel-vba.com/vba-code-2-1-tips.htm)

Excel VBA -- Adding Code to a Workbook
Excel VBA -- Adding Code to a Workbook (http://www.contextures.com/xlvba01.html)

Learning about EXCEL macros (http://www.excel-vba.com/)
Getting Started with Macros and User Defined Functions (http://www.mvps.org/dmcritchie/excel/getstarted.htm)
Microsoft Excel Links / Microsoft Excel Tips / Excel Tutorial / Excel Spreadsheet Help / Excel Tip .com (http://www.exceltip.com/excel_links.html)

(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 (http://www.cpearson.com/excel/debug.htm)

Excel Tutorials / Video Tutorials - Functions
Excel VLookup Function and VLookup Example (http://www.contextures.com/xlFunctions02.html)

XL-CENTRAL.COM: Your Quick Reference to Microsoft Excel Solutions (http://www.xl-central.com/index.html)

DataPig Technologies (http://www.datapigtechnologies.com/ExcelMain.htm)

Cascading queries

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

Excel VLOOKUP Function and VLOOKUP Example
Excel VLookup Function and VLookup Example (http://www.contextures.com/xlFunctions02.html)

INDEX MATCH - Excel Index Function and Excel Match Function
Excel VLookup Function and VLookup Example (http://www.contextures.com/xlFunctions03.html)

Excel Data Validation -- Dependent Lists (http://www.contextures.com/xlDataVal02.html)
Excel Data Validation List from Another Workbook (http://www.contextures.com/xlDataVal05.html)
Excel Data Validation Tips and Quirks (http://www.contextures.com/xlDataVal08.html#Larger)

Excel Data Validation - Add New Items
Excel Data Validation - Add New Items (http://www.contextures.com/excel-data-validation-add.html)

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 (http://www.cpearson.com/Excel/vbe.aspx)

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 (http://www.pcreview.co.uk/forums/thread-978054.php)

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 (http://www.mrexcel.com/learnexcel2.shtml)

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 (http://www.contextures.com/xlUserForm01.html)

DonkeyOte: My Recommended Reading
Volatility
Volatile Excel Functions -Decision Models (http://www.decisionmodels.com/calcsecretsi.htm)

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 (http://www.xtremevbtalk.com/showthread.php?t=296012)

Pivot Intro
Using Pivot Tables and Pivot Charts in Microsoft Excel (http://peltiertech.com/Excel/Pivots/pivotstart.htm)

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 (http://www.experts-exchange.com/Soft..._22844558.html)
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 (http://www.rondebruin.nl/sendmail.htm)

Outlook VBA
Writing VBA code for Microsoft Outlook (http://www.outlookcode.com/article.aspx?ID=40)

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

Function Translations
Excel 2007 function name translations - Dictionary Chart Front Page (http://www.piuha.fi/excel-function-name-translation/)

Dynamic Named Ranges
Excel Names -- Excel Named Ranges (http://www.contextures.com/xlNames01.html)

How to create Excel Dashboards
Excel Dashboard Templates (http://www.contextures.com/excel-dashboards.html)
Excel Dashboards - Templates, Tutorials, Downloads and Examples | Chandoo.org - Learn Microsoft Excel Online (http://chandoo.org/wp/excel-dashboards/)
Excel Dashboards - Templates, Tutorials, Downloads and Examples | Chandoo.org - Learn Microsoft Excel Online (http://chandoo.org/wp/management-dashboards-excel/)
Free Microsoft Excel Dashboard Widgets to Download (http://www.exceldashboardwidgets.com/)

Excel Dashboard / Scorecard Ebook
Excel Dashboards and Scorecards Ebook | How to Create Dashboards in Excel (http://www.qimacros.com/excel-dashboard-scorecard.html)

Templates
CPearson.com Topic Index (http://www.cpearson.com/Excel/Topic.aspx)
Excel Template - Golf Scores (http://www.contextures.com/excel-template-golf-scores.html)

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

Date & Time stamping:
McGimpsey & Associates : Excel : Time and date stamps (http://www.mcgimpsey.com/excel/timestamp.html)

Get Formula / Formats thru custom functions:
Show FORMULA or FORMAT of another cell (http://dmcritchie.mvps.org/excel/formula.htm#GetFormat)

A nice informative MS article "Improving Performance in Excel 2007"
Improving Performance in Excel 2007 (http://msdn.microsoft.com/en-us/library/aa730921.aspx)

Progress Meters
AJP Excel Information - Progress meters (http://www.andypope.info/vba/pmeter.htm)
Excel (http://www.xcelfiles.com/ProgressBar.html)


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 ..