[SOLVED] VBA source or reference


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 31st August 2009, 23:09
pogiman via OfficeKB.com's Avatar
pogiman via OfficeKB.com
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default VBA source or reference
     Excel: VBA   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: VBA   

What book or site (other than www.officekb.com) would you recommend to learn
Excel VBA (or VBA even in other MS Office applications)?

Though I could search the internet for VBA codes whenever I need one but I
really want to learn and equip myself with it.

Thanks for your response.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200908/1




The Code Cage Advertisment
Advertisement
  #2  
Old 31st August 2009, 23:24
stanleydgromjr's Avatar
stanleydgromjr stanleydgromjr is offline
Junior Member
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient at manipulating data
 
Join Date: Jul 2009
Location: Northeast Pennsylvania, USA
Posts: 56
Posts Per Day: 0.02
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 32 (9) stanleydgromjr is on a distinguished road
USA
Default Re: VBA source or reference

------ Register to get rid of these "In Post" ads! ------


pogiman via OfficeKB.com,

Training / Books / Sites:

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
Visual Basic Macros Made Easy

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

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

Free Help on VBA for 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

Excel 2003 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


Have a great day,
Stan



1 members found this post helpful.
  #3  
Old 1st September 2009, 03:17
pogiman via OfficeKB.com's Avatar
pogiman via OfficeKB.com
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: VBA source or reference

------ Register to get rid of these "In Post" ads! ------


I see I have a lot of catching up to do.

Thank you very much stanleydgromjr.

stanleydgromjr wrote:
>pogiman via OfficeKB.com,
>
>Training / Books / Sites:
>
>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
>'Visual Basic Macros Made Easy' (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)
>
>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)
>
>'Free Help on VBA for 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 / Exce
>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
>
>Excel 2003 Power Programming with VBA, by John Walkenbach
>VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Trac
>Syrstad
>Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Train
>Hawley
>VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" an
>Tracy Syrstad
>
>Excel 2007 Book: you can try this...there is a try before you bu
>ebook available at this link…
>'Learn Excel 97 through 2007 from Mr Excel - Revised and Expande
>Second Edition' (http://www.mrexcel.com/learnexcel2.shtml)
>
>Have a great day,
>Sta
>
>--
>stanleydgromj


--
Message posted via http://www.officekb.com




The Code Cage Advertisment
Advertisement
  #4  
Old 28th April 2010, 07:29
seena's Avatar
seena seena is offline
Junior Member
MS Office Version: MS Office 97
MS Office Skill Level: New to MS Office
 
Join Date: Apr 2010
Location: United States
Age: 31
Posts: 1
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 0 (0) seena is an unknown quantity at this point
USA
Default Re: VBA source or reference

------ Register to get rid of these "In Post" ads! ------


What percentage of your development time would you say that you spend debugging code? Most developers I've talked to say they spend anywhere from 30% to 50% or more of their time -- not writing the code -- but debugging and fixing it. Not only do we use the debugger to check code we've written before we can go on to write some more, we also use it in testing a completed project under various sce...
__________________
seena



0 members found this post helpful.
  #5  
Old 28th April 2010, 09:01
Bob Phillips's Avatar
Bob Phillips
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: VBA source or reference

------ Register to get rid of these "In Post" ads! ------


80%, and the other 80% writing code.

--

HTH

Bob

"seena" <seena.4a48gm@thecodecage.com> wrote in message
news:seena.4a48gm@thecodecage.com...
>
> What percentage of your development time would you say that you spend
> debugging code? Most developers I've talked to say they spend anywhere
> from 30% to 50% or more of their time -- not writing the code -- but
> debugging and fixing it. Not only do we use the debugger to check code
> we've written before we can go on to write some more, we also use it in
> testing a completed project under various sce...
>
>
> --
> seena
>
> seena
> ------------------------------------------------------------------------
> seena's Profile: http://www.thecodecage.com/forumz/member.php?u=1810
> View this thread:
> http://www.thecodecage.com/forumz/sh...d.php?t=130241
>
> http://www.thecodecage.com/forumz
>






The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
reference, source, vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 07:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.18968 seconds
  • Memory Usage 6,418KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (3)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (5)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (5)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_ctoptip
  • (2)postbit_onlinestatus
  • (2)postbit_reputation
  • (5)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (3)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php
  • ./includes/functions_prefix.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • reputation_power
  • reputation_image
  • postbit_imicons
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete