Powered by Invision Power Board

Recommended Sites: - VBA Express - JMT Forums - MrExcel - Ozgrid - MS Discussion Groups - John Walkenbach - Chip Pearson - Stephen Bullens Excel Page - xlDynamic (Bob Phillips) - JKP (Jan Karel Pieterse) - The Xcel Files (Ivan F Moala) - The Excel Maniacs (Gareth) - Scriptorium (Rembo) - ExcelKB (XL-Dennis) - and don't forget to register here - it's free!...
  Start new topic

Excel VBA Handy Code
Topic Title Topic Starter Replies Views Last Action
No New Posts   About dialog (API)
johnske 0 359 March 20, 2006
Last Post by: johnske
No New Posts   Add UDF description to function wizard
johnske 0 415 January 03, 2007
Last Post by: johnske
No New Posts   AddIn - Auto Install an .xls file as an add-in
(Basic version)		 johnske 0 451 October 02, 2006
Last Post by: johnske
No New Posts   Arrays - access an element of an array
johnske 0 346 March 20, 2006
Last Post by: johnske
No New Posts   Arrays - count items in an array
johnske 0 1,662 March 20, 2006
Last Post by: johnske
No New Posts   Arrays - put a data column into an array (e.g.)
johnske 0 337 March 20, 2006
Last Post by: johnske
No New Posts   Attributes - change (all workbooks in folder)
johnske 0 372 March 20, 2006
Last Post by: johnske
No New Posts   Bug Report
johnske 0 297 September 04, 2006
Last Post by: johnske
No New Posts   BuiltinDocumentProperties - change
johnske 0 698 March 20, 2006
Last Post by: johnske
No New Posts   Calendar control - standard calendar
Passing variables between controls demo		 johnske 1 796 March 30, 2006
Last Post by: johnske
No New Posts   Chart - add embedded chart via VBA
johnske 0 854 October 10, 2007
Last Post by: johnske
No New Posts   Clean up text
Remove extraneous 'junk' from text		 johnske 0 325 March 24, 2006
Last Post by: johnske
No New Posts   Clipboard - clear items
johnske 0 793 March 20, 2006
Last Post by: johnske
No New Posts   Code as you go (take two)
johnske 0 319 April 20, 2006
Last Post by: johnske
No New Posts   Code modules - Exporting
johnske 0 278 May 08, 2006
Last Post by: johnske
No New Posts   Code modules - Importing
johnske 0 286 May 08, 2006
Last Post by: johnske
No New Posts   Code modules - Removing
johnske 0 260 May 08, 2006
Last Post by: johnske
No New Posts   Colour indexes - list (with examples)
johnske 0 270 March 20, 2006
Last Post by: johnske
No New Posts   Column Letter - get it
johnske 0 1,244 March 20, 2006
Last Post by: johnske
No New Posts   Conditional format some cells in a row
johnske 0 331 March 20, 2006
Last Post by: johnske
No New Posts   ControlTipText for worksheet objects
(From Celeste)		 johnske 0 551 March 24, 2006
Last Post by: johnske
No New Posts   Convert entire column to Proper case
(From mdmackillop)		 johnske 0 342 June 01, 2007
Last Post by: johnske
No New Posts   Copy cell formulas - (no Copy/Paste)
johnske 0 311 April 04, 2006
Last Post by: johnske
No New Posts   Copy colours from another book
johnske 0 224 March 20, 2006
Last Post by: johnske
No New Posts   Count & list all files on desktop
johnske 0 275 March 20, 2006
Last Post by: johnske
No New Posts   Count number of data cells
johnske 0 660 March 20, 2006
Last Post by: johnske
No New Posts   Cross reference function
johnske 0 303 March 20, 2006
Last Post by: johnske
No New Posts   Custom BeforeClose/BeforeSave dialog
johnske 0 444 December 25, 2006
Last Post by: johnske
No New Posts   Custom filter - multi criteria
johnske 0 389 May 13, 2007
Last Post by: johnske
No New Posts   Delete Duplicate Rows
johnske 0 823 March 27, 2007
Last Post by: johnske
No New Posts   Dialogs - excel
johnske 0 431 June 25, 2006
Last Post by: johnske
No New Posts   Double-click a cell (API)
johnske 0 521 March 20, 2006
Last Post by: johnske
No New Posts   Double-click a cell (SendKeys)
johnske 0 815 March 20, 2006
Last Post by: johnske
No New Posts   Drives - get hard drive letter
johnske 0 418 March 20, 2006
Last Post by: johnske
No New Posts   Drives - Get Hard-drive serial number
johnske 0 305 November 09, 2006
Last Post by: johnske
No New Posts   Drives - get info
johnske 0 351 June 07, 2006
Last Post by: johnske
No New Posts   Email active sheet as attachment
(use default email program)		 johnske 0 291 March 20, 2006
Last Post by: johnske
No New Posts   Email active sheet as attachment with message
(use default email program)		 johnske 0 240 March 20, 2006
Last Post by: johnske
No New Posts   Email active sheet as body of mail - Call + msg
(use default email program)		 johnske 0 815 May 30, 2006
Last Post by: johnske
No New Posts   Email active sheet as body of mail - Call + msg
(From XL-Dennis - using Outlook Express)		 johnske 0 258 June 02, 2006
Last Post by: johnske
No New Posts   Email active sheet as body of mail - Call example
(use default email program)		 johnske 0 573 May 30, 2006
Last Post by: johnske
No New Posts   Email active sheet as body of mail in PERSONAL.xls
(use default email program)		 johnske 0 225 May 30, 2006
Last Post by: johnske
No New Posts   Email active sheet Range as body of mail - Call
(From MS support, using Outlook 2002-03)		 johnske 0 550 June 02, 2006
Last Post by: johnske
No New Posts   Email active workbook as attachment
(use default email program)		 johnske 0 223 March 20, 2006
Last Post by: johnske
No New Posts   Email active workbook as attachment
(using SendMail dialog)		 johnske 0 289 June 07, 2006
Last Post by: johnske
No New Posts   Email active workbook as attachment with message
(use default email program)		 johnske 0 325 March 20, 2006
Last Post by: johnske
No New Posts   Email active workbook as attachment with message
(Using xlDialogSendMail & default email)		 johnske 0 286 November 12, 2006
Last Post by: johnske
No New Posts   Email selected sheets as attachment
(use default email program)		 johnske 0 204 March 20, 2006
Last Post by: johnske
No New Posts   Email selected sheets as attachment with message
(use default email program)		 johnske 0 245 March 20, 2006
Last Post by: johnske
No New Posts   Email sheet, assign code to buttons on sheet
johnske 0 294 April 09, 2006
Last Post by: johnske
No New Posts   Error message - generating some
(Error description examples)		 johnske 0 255 March 24, 2006
Last Post by: johnske
No New Posts   Event code - add it programmatically
(Use of CreateEventProc)		 johnske 0 253 April 09, 2006
Last Post by: johnske
No New Posts   Excels Camera function - using it
(CopyPicture)		 johnske 0 428 March 20, 2006
Last Post by: johnske
No New Posts   Excels Random function - how random is it?
Coin tosses with option to bias coin		 johnske 0 215 March 20, 2006
Last Post by: johnske
No New Posts   Exclude numbers from text entry
johnske 0 246 January 19, 2007
Last Post by: johnske
No New Posts   Export pictures from Excel
johnske 0 2,176 April 10, 2006
Last Post by: johnske
No New Posts   FileExists function
johnske 0 625 June 28, 2006
Last Post by: johnske
No New Posts   Find file function
johnske 0 1,103 March 20, 2006
Last Post by: johnske
No New Posts   Find Function
johnske 0 610 March 20, 2006
Last Post by: johnske
No New Posts   Get Data from Closed Book
(Create then delete links)		 johnske 0 369 March 20, 2006
Last Post by: johnske
No New Posts   GetOpenFilename demo
johnske 0 361 March 20, 2006
Last Post by: johnske
No New Posts   Gosub and Return - use of
For repetitive operations		 johnske 0 535 March 20, 2006
Last Post by: johnske
No New Posts   GUID - add/remove reference programmatically
johnske 0 1,595 April 07, 2006
Last Post by: johnske
No New Posts   GUID references (list them)
johnske 0 512 March 20, 2006
Last Post by: johnske
No New Posts   Hard Drive Serial Number (get it)
johnske 0 381 June 28, 2007
Last Post by: johnske
No New Posts   Hide & unhide columns (except some cells)
(Idea from Bob Phillips)		 johnske 0 611 March 20, 2006
Last Post by: johnske
No New Posts   Hide some sheets - unhide others
johnske 0 375 March 27, 2007
Last Post by: johnske
No New Posts   ID a shape using right-click menus
(Shapes/Lines/Pictures/WordArt/Controls)		 johnske 0 761 April 10, 2006
Last Post by: johnske
No New Posts   ID all worksheet shapes (inc pictures)
johnske 0 305 April 10, 2006
Last Post by: johnske
No New Posts   ID Command bars
johnske 0 398 March 20, 2006
Last Post by: johnske
No New Posts   ID OLE objects - get ID
johnske 0 259 March 24, 2006
Last Post by: johnske
No New Posts   InputBox Cancel button
(method Vs function)		 johnske 0 1,831 September 16, 2006
Last Post by: johnske
No New Posts   Install Template automatically
johnske 0 262 June 22, 2006
Last Post by: johnske
No New Posts   Iterate through all possibilities
johnske 0 258 March 20, 2006
Last Post by: johnske
No New Posts   Last row/Next row - finding last & selecting next
Five methods and techniques...		 johnske 4 2,243 June 18, 2006
Last Post by: johnske
No New Posts   Links - delete all
johnske 0 220 May 04, 2006
Last Post by: johnske
No New Posts   Links - delete or list external links in formulas
johnske 0 679 May 24, 2006
Last Post by: johnske
No New Posts   List all open workbooks
johnske 0 680 March 20, 2006
Last Post by: johnske
No New Posts   Lock/Unlock VBA Project programmatically
(using SendKeys)		 johnske 0 2,078 June 09, 2006
Last Post by: johnske
No New Posts   Manipulating images - jigsaw
(Basis for game)		 johnske 0 409 April 10, 2006
Last Post by: johnske
No New Posts   Monitor Metrics (API)
johnske 0 274 March 20, 2006
Last Post by: johnske
No New Posts   Move file or folder
(using Name-As Method)		 johnske 0 363 March 20, 2006
Last Post by: johnske
No New Posts   Move or copy folders
(using FileSystemObject)		 johnske 0 210 March 20, 2006
Last Post by: johnske
No New Posts   Multi-column list boxes
(with multi-select)		 johnske 0 784 March 24, 2006
Last Post by: johnske
No New Posts   Number Rows
johnske 0 264 September 10, 2006
Last Post by: johnske
No New Posts   Only show one sheet at a time (hide all others)
johnske 0 786 November 29, 2006
Last Post by: johnske
No New Posts   Open all books in folder with similar names
johnske 0 206 March 20, 2006
Last Post by: johnske
No New Posts   Opening workbooks with VBA - functions
(Test if file exists or is open)		 johnske 0 291 December 30, 2006
Last Post by: johnske
No New Posts   Operating system folder workaround
johnske 0 230 March 18, 2007
Last Post by: johnske
No New Posts   Parsing in Excel
(Parse method)		 johnske 0 986 March 15, 2007
Last Post by: johnske
No New Posts   Password property example
johnske 0 294 March 20, 2006
Last Post by: johnske
No New Posts   Paths - default
johnske 0 275 July 06, 2006
Last Post by: johnske
No New Posts   Pattern matching using "Like"
Analyze each letter in a string		 johnske 0 728 January 25, 2007
Last Post by: johnske
No New Posts   Pause Function
johnske 0 930 March 20, 2006
Last Post by: johnske
No New Posts   Printer - show printer properties
johnske 0 321 October 22, 2007
Last Post by: johnske
No New Posts   Protection: Delete all VBA if VBA password cracked
johnske 0 484 September 28, 2006
Last Post by: johnske
No New Posts   Protection: Sheet password cracker
johnske 0 469 February 10, 2007
Last Post by: johnske
No New Posts   Protection: Workbook password cracker
johnske 0 386 February 11, 2007
Last Post by: johnske
No New Posts   Put like data on different sheets
(extracting from one sheet) & TOC		 johnske 0 261 March 20, 2006
Last Post by: johnske
No New Posts   Range multi-select (example)
johnske 0 449 March 20, 2006
Last Post by: johnske
No New Posts   Remove all VBA code and objects
johnske 0 474 July 09, 2007
Last Post by: johnske
No New Posts   Replace formula with value on entry
johnske 0 313 April 21, 2007
Last Post by: johnske
No New Posts   Replace pilcrows after pasting to text box
(The pilcrow is the ΒΆ symbol)		 johnske 0 256 March 20, 2006
Last Post by: johnske
No New Posts   Replace wildcard chars * and ? on s/sheet
johnske 0 630 March 20, 2006
Last Post by: johnske
No New Posts   Restrict action to a given Column or Row
johnske 0 266 March 20, 2006
Last Post by: johnske
No New Posts   Restrict action to a given range
johnske 0 263 March 20, 2006
Last Post by: johnske
No New Posts   Rounding a number to the nearest half
johnske 0 435 March 24, 2006
Last Post by: johnske
No New Posts   Run procedure in another workbook
johnske 0 288 April 04, 2006
Last Post by: johnske
No New Posts   Save a password in a text box
johnske 0 256 March 20, 2006
Last Post by: johnske
No New Posts   Save all sheets as new book - no macros
johnske 0 1,828 January 28, 2008
Last Post by: johnske
No New Posts   Search closed workbooks for VBA code
(search all code modules for keyword(s))		 johnske 0 268 March 20, 2006
Last Post by: johnske
No New Posts   Search FOR wildcard characters (2 methods)
johnske 0 912 March 20, 2006
Last Post by: johnske
No New Posts   Security - Trust access to visual basic project
(Error message work-around)		 johnske 0 901 August 06, 2006
Last Post by: johnske
No New Posts   Security - Workbook only opens on one PC
(works by checking the HD serial number)		 johnske 0 339 November 09, 2006
Last Post by: johnske
No New Posts   Select Case allied with 'Like' operator
(from Matt Vidas)		 johnske 0 1,226 September 04, 2006
Last Post by: johnske
No New Posts   Self-destructing Workbook
(from brettdj)		 johnske 0 353 September 29, 2006
Last Post by: johnske
No New Posts   Sheet Activate Dialog
johnske 0 312 March 20, 2006
Last Post by: johnske
No New Posts   SheetExists/ChartExists functions
johnske 0 427 June 28, 2006
Last Post by: johnske
No New Posts   Sheets - copy sheet array, save as new book
johnske 0 659 December 20, 2006
Last Post by: johnske
No New Posts   Sheets codename - reference it in loop
johnske 0 656 March 20, 2006
Last Post by: johnske
No New Posts   Sorting - more than 3 Keys
johnske 0 1,115 March 04, 2007
Last Post by: johnske
No New Posts   Special cells
johnske 0 886 April 01, 2006
Last Post by: johnske
No New Posts   Special Symbols
johnske 0 492 March 20, 2006
Last Post by: johnske
No New Posts   SpecialCells functionality
User to complete missing data (no loops)		 johnske 0 268 June 03, 2007
Last Post by: johnske
No New Posts   Spellcheck using UK English
johnske 0 234 February 23, 2007
Last Post by: johnske
No New Posts   Superfast sorted unique list
(to populate combobox or listbox)		 johnske 0 276 February 26, 2007
Last Post by: johnske
No New Posts   UDFs for NETWORKDAYS and EOMONTH (VBA)
(duplicates Analysis Toolpak functions)		 johnske 0 897 July 16, 2007
Last Post by: johnske
No New Posts   Unique items (collection)
johnske 0 728 March 20, 2006
Last Post by: johnske
No New Posts   Use cell values to call procedures
(worksheet change event)		 johnske 0 244 March 20, 2006
Last Post by: johnske
No New Posts   UserForm chart
johnske 0 1,303 April 11, 2006
Last Post by: johnske
No New Posts   VB project - get it
(from Bob Phillips - I think)		 johnske 0 366 March 20, 2006
Last Post by: johnske
No New Posts   VBA code lines - count number of lines in project
johnske 0 547 March 20, 2006
Last Post by: johnske
No New Posts   VBE "Copy and Paste"
(Copy module code to a number of books)		 johnske 0 316 October 25, 2006
Last Post by: johnske
No New Posts   VBE - Add new Help control to menu
(from Chip Pearson)		 johnske 0 315 May 26, 2006
Last Post by: johnske
No New Posts   VBE - Copy code to clipboard
(plus GetFromClipboard example useage)		 johnske 0 278 February 01, 2007
Last Post by: johnske
No New Posts   VBE tools - actuate programmatically
Using Execute		 johnske 0 326 May 26, 2006
Last Post by: johnske
No New Posts   VBE window - Open/Close programmatically
johnske 0 536 April 09, 2006
Last Post by: johnske
No New Posts   Windows search dialog - call (API)
johnske 0 318 March 20, 2006
Last Post by: johnske
No New Posts   WordArt - add, fix size and position on sheet
johnske 0 366 April 11, 2006
Last Post by: johnske
No New Posts   Workbook name with no .xls on end...
johnske 0 264 April 07, 2006
Last Post by: johnske
No New Posts   Worksheet sort
(Bubble-sort sheets)		 johnske 0 265 December 30, 2006
Last Post by: johnske
No New Posts   Worksheet test
(run code if it's a worksheet)		 johnske 0 269 December 03, 2006
Last Post by: johnske
No New Posts   Zoom/Unzoom all sheets
(On-key method)		 johnske 0 654 March 20, 2006
Last Post by: johnske
0 User(s) are browsing this forum (0 Guests and 0 Anonymous Users)
0 Members:
Showing 143 of 143 topics sorted by in from  

  Start new topic

Legend

Open Topic
(new replies)
Open Topic
(no new)
Hot Topic
(new replies)
Hot Topic
(no new)
Poll
(new votes)
Poll
(no new)
Locked
Topic
Moved
Topic
This additional symbol: indicates that you have participated in the topic
Search this forum: 
  Forum Jump:
 



Mark this forum as read



Get your own forum today!
Signup
Support
Contribute
Adding a Forumer™ community to your website is a great way to get return visitors. Create a forum and see how a loyal community of users will propel your site/product/business to a new level. It takes 15 seconds to get started!
Forumer phpBB3
Forumer phpBB2
Forumer IPB
Support | KB
Terms of Use
Report Abuse
Privacy Policy
Arch | s3
fContribute
Powered by Forumer & IPB © 2003-2009. All Rights Reserved.