INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

VBA Visual Basic for Applications (Microsoft) FAQ Index

FAQ Index

Excel How To

FAQ Title Author Date Rating/#
Adding a group of menu items to other menu bars  faq707-5933 shetlandbob 24 Jun 05 5.5 / 2
Adding a menu item to EXCEL programmatically  faq707-5255 taupirho 19 May 05 6.2 / 5
Capturing Date and Workbook Related Information In Excel Using Formulae and VBA   faq707-5039 Harlequin007 15 Apr 04 6.1 / 8
Count a set of cells based on their colour  faq707-6049 xlbo 2 Sep 05 9.0 / 4
Does a file exist?   faq707-1936 gs99 19 May 02 5.6 / 8
Get an EXCEL cell address from its row/column number  faq707-5254 taupirho 28 Jun 07 7.8 / 9
How Can i convert a excel spreadsheet to a XML File   faq707-6257 Chance1234 23 Mar 06 5.5 / 2
How can I define one range MINUS another intersecting range   faq707-7135 SkipVought 11 Feb 09 --
How can I identify UsedRange OR last/first column/row etc.  faq707-2112 Loomah 24 Mar 07 8.4 / 25
How can i quickly reduce my test data   faq707-6261 Chance1234 23 Mar 06 --
How can I recover my VBA code from a corrupt workbook that won't open   faq707-5899 xlbo 7 Jun 05 10.0 / 1
How can I Transpose Data In Excel Via VBA   faq707-6212 Chance1234 15 Feb 06 10.0 / 1
How can I use VBA to get my Access into Excel?   faq707-5844 01Patrik 29 Apr 05 9.0 / 1
How do I find the REAL last used cell  faq707-2115 xlbo 8 Dec 06 8.0 / 29
How Do I save a sheet seperately from the main workbook?   faq707-2482 xlbo 28 Nov 02 8.5 / 13
How to Add a DateStamp in Excel   faq707-1657 SkipVought 19 Mar 02 7.7 / 14
How to Find the Ne Printer Number in Excel VBA   faq707-7509 sxschech 22 Aug 11 --
How to find TOTAL NUMBER OF PRINT PAGES in VBA   faq707-4390 SkipVought 4 Nov 03 9.0 / 2
Insert a picture into a cell's comment box  faq707-7583 renigar 22 Sep 12 --
Name a Chart Object on a Worksheet   faq707-4055 MeGustaXL 21 Aug 03 9.5 / 4
Prevent Excel From Closing   faq707-5478 AccessGuruCarl 19 Oct 04 --
Save A Formula As A Comment   faq707-2892 LoNeRaVeR 17 Dec 02 5.7 / 3
So where exactly do I put this macro code then??  faq707-5758 KenWright 16 Mar 05 8.3 / 6
Validate a UK Postcode  faq707-6344 idbr 19 Jul 06 --
WebQuery for web sites that require a log in   faq707-6400 CautionMP 6 Sep 06 4.0 / 3
Write an Excel function to write data to a worksheet   faq707-5379 lancish 12 Aug 04 2.5 / 2
 

Microsoft Word How To?

FAQ Title Author Date Rating/#
How quickly can i update data in a word document   faq707-6139 Chance1234 13 Dec 05 --
How to see if DOC file is already open?   faq707-1265 JoaoTL 11 Nov 01 6.8 / 6
Set Focus In Multipage Object   faq707-5903 mdav2 9 Jun 05 --
UNDO using VBA in Word 2010   faq707-7535 PWD 20 Dec 11 --
Worksheet protection and autofilters   faq707-1453 Klopper 15 Jan 02 8.7 / 3
 

Names Collection

FAQ Title Author Date Rating/#
How to get a cell's name.  faq707-298 MissyEd 23 Nov 00 5.3 / 3
How to get all the names in a workbook  faq707-297 MissyEd 23 Nov 00 5.7 / 6
Inserting an External File Into a MS Word FormField using a Command Button   faq707-908 Delano29 12 Jul 01 5.0 / 4
 

Office / VBA General

FAQ Title Author Date Rating/#
A useful class property for International IS0 country codes   faq707-6741 Chance1234 29 Sep 07 --
How can I Disable/Enable CommandBars and/or Controls   faq707-4841 Loomah 12 Feb 04 7.3 / 9
How Do I create an Ordinal (legal) date format in VBA   faq707-6742 Chance1234 2 Oct 07 --
How do I bypass the Outlook security message when trying to automate emails   faq707-5230 xlbo 23 Jun 04 8.8 / 10
How do I bypass the Outlook security message when trying to automate emails (Best option)   faq707-7540 thefarg 26 Jan 12 --
How to add Registry entries from special text file   faq707-4366 SBendBuckeye 29 Oct 03 10.0 / 1
How to use SendKeys to imitate the keyboard   faq707-5037 BrainB 15 Apr 04 3.0 / 3
IsNothing Function since I always forget it is not part of VBA IsSomething functions   faq707-3834 SBendBuckeye 5 Jul 03 8.2 / 5
List environment variables   faq707-4296 xlbo 13 Oct 03 8.6 / 7
Loop Through Filters Adding Criteria to A String   faq707-6288 idbr 27 Apr 06 --
Nulls and Other Nothings - An Explanation  faq707-3710 TonyJollans 8 May 04 8.3 / 21
Sort a data range by double-clicking header cell   faq707-4886 VBAjedi 25 Feb 04 2.0 / 1
Unblocking ActiveX controls in Vista / IE  faq707-7241 GVF 24 Nov 09 2.0 / 1
Variable Naming Conventions... Avoid the Pit Falls.   faq707-4273 SQLBI 7 Oct 03 8.7 / 3
What are the CommandBar Control Names and IDs in Word & Excel   faq707-4727 Loomah 16 Jan 04 9.3 / 4
What is the difference between Access and Excel?   faq707-4547 rdodge 5 Dec 03 6.5 / 11
 

Outlook VBA

FAQ Title Author Date Rating/#
How can I create a New Outlook Folder in Code   faq707-6232 Chance1234 3 Mar 06 --
How do i go through a folder in outlook and save the attachments ?   faq707-5368 Chance1234 10 Aug 04 6.7 / 3
 

Powerpoint

FAQ Title Author Date Rating/#
A Quick introduction to Slides Tags   faq707-6258 Chance1234 23 Mar 06 --
How can I name objects in Powerpoint to reference in VBA code ?   faq707-1698 Chance1234 27 Mar 02 9.0 / 2
How Do I populate a table in Powerpoint with data ?   faq707-6256 Chance1234 23 Mar 06 --
VBA code to insert Linked Objects in Power Point   faq707-4833 SkipVought 11 Feb 04 6.0 / 3
Working with Horizontal and Vertical Slides   faq707-6259 Chance1234 23 Mar 06 --
 

Presentation

FAQ Title Author Date Rating/#
How do I "hide" Excel?   faq707-1572 JESTAR 5 Mar 02 8.1 / 13
Make the worksheet columns automatically change size to fit the longest entry   faq707-4000 JESTAR 7 Aug 03 6.3 / 4
 

Protection

FAQ Title Author Date Rating/#
How do I protect a VBA Project in Excel?   faq707-644 LoNeRaVeR 12 Apr 01 8.6 / 10
 

VB Application w/ Outlook 2002

FAQ Title Author Date Rating/#
Outlook 2002 disallows VB app to send emails   faq707-1904 jsnull 10 May 02 7.3 / 7
 

VBA For Beginners

FAQ Title Author Date Rating/#
VBA Forum - Beginners FAQ   faq707-5689 fumei 16 Feb 05 6.5 / 25
 

VBA How To

FAQ Title Author Date Rating/#
A quicker way to get data into EXCEL from an ODBC data source   faq707-5258 taupirho 29 Jun 04 --
A simple error handling technique for VB/VBA apps  faq707-5253 taupirho 19 May 05 5.8 / 5
Add min/max buttons to a userform   faq707-4773 Nelviticus 26 Jan 04 10.0 / 1
After setting a forms RecordSource Why doesn't form display data   faq707-4754 turbosrl 22 Jan 04 --
Charts & VBA  faq707-4811 SkipVought 5 Dec 12 6.0 / 2
Close the Internet Explorer Window   faq707-6073 jennuhw 12 Oct 05 --
Concatenate strings more efficiently   faq707-5195 taupirho 10 Jun 04 4.0 / 1
Create Control Arrays in VBA UserForms   faq707-4085 Bowers74 28 Aug 03 6.6 / 7
Create User Form Using VBA  faq707-5757 PBAPaul 29 Nov 05 6.8 / 8
Create your own Property   faq707-3402 SteveBausch 2 Apr 03 9.5 / 2
Creating a control (flexgrid) programmatically in VB/VBA   faq707-5257 taupirho 29 Jun 04 --
Creating and displaying an initial 'splash' Excel/VBA Userform  faq707-5252 taupirho 19 May 05 3.7 / 3
Disable the "queryclose" button (the little X)   faq707-2697 JESTAR 4 Nov 02 7.0 / 3
Errors when using command buttons   faq707-3607 xlbo 20 May 03 7.5 / 2
File and Folder Procedures  faq707-4116 Bowers74 8 May 04 8.8 / 77
How Can I Make My Code Run Faster?  faq707-4105 SkipVought 18 Sep 17 8.5 / 33
How can I send a variable to the clipboard ?   faq707-6685 Chance1234 19 Jul 07 --
How do I create a Message Box which doesn't lock the Application?   faq707-4699 TonyJollans 12 Jan 04 7.9 / 13
How Do I open A Folder In Explorer From VBA   faq707-6756 Chance1234 19 Oct 07 10.0 / 1
How to automate web forms from VBA using Internet Explorer  faq707-6399 CautionMP 10 Sep 06 10.0 / 5
How to generate an XML document from within VBA  faq707-7736 jrbarnett 9 Oct 14 --
How to use the Watch Window as a Power Programming Tool   faq707-4594 SkipVought 16 Dec 03 6.3 / 13
Increment text, such as G-0001, to the next number-like text in Access  faq707-7571 GregSmithAlaska 23 Jul 12 --
Insert data (from a form) into the next empty row on a worksheet   faq707-4001 JESTAR 7 Aug 03 3.3 / 3
Killing a window/userform based on its caption.   faq707-5259 taupirho 29 Jun 04 --
Loop Through Controls on a UserForm. Textbox, ComboBox, CheckBox etc   faq707-6170 Chance1234 12 Jan 06 6.0 / 2
Moving a VB window or VBA userform that doesn't have a title bar   faq707-5251 taupirho 29 Jun 04 5.0 / 2
Open File(s) using the GetOpenFilename dialog  faq707-4114 Bowers74 8 May 04 9.3 / 10
Password Character InputBox (hiding text in a vba inputbox)   faq707-4617 Chattin 22 Dec 03 9.8 / 5
Pause VBA code until "Shelled" event is complete   faq707-2542 ETID 4 Oct 02 6.7 / 3
Pulling data from Access into another MS App (via DAO)   faq707-2281 RSi2 5 Aug 02 4.6 / 5
Refer to Worksheets more effecively in a Procedure   faq707-4090 Bowers74 20 Dec 03 8.6 / 16
Remove the title bar from a userform   faq707-5196 taupirho 10 Jun 04 --
Restrict data entry in userform text boxes  faq707-5194 taupirho 19 May 05 1.0 / 1
Run-time error '1004': Select method of Range class failed   faq707-7380 PWD 25 Aug 10 1.0 / 1
Send an Email In Excel without Prompts   faq707-4334 robcarr 22 Oct 03 7.6 / 9
Send email from Excel through Outlook 97 (with or without attachments)   faq707-3564 VBAjedi 6 Nov 03 8.8 / 11
Set "do not autoarchive" in Outlook progmmatically   faq707-5081 redapples 28 Apr 04 --
Setting up a Data Source Name(DSN) programmatically in VB/VBA  faq707-5256 taupirho 6 Jul 04 --
Show a Message Box for a specified time.   faq707-5032 PBAPaul 13 Apr 04 10.0 / 2
Sorting a programmatically created MSFLEXGRID by double clicking on its header columns   faq707-5260 taupirho 29 Jun 04 --
Trapping xl Application Events   faq707-4195 JohnAcc 19 Sep 03 7.3 / 4
Understanding events. I: The basics   faq707-4973 combo 23 Mar 04 6.8 / 6
Understanding events. II: Automation events   faq707-4974 combo 23 Mar 04 6.0 / 4
Understanding events. III: Some useful stuff   faq707-4975 combo 23 Mar 04 6.7 / 3
Understanding events. IV: A substitute for control arrays in VBA  faq707-4976 combo 5 Apr 04 9.5 / 4
Use ODBC to read CSV text files with SQL   faq707-5250 taupirho 29 Jun 04 6.0 / 1
What are Object Events and how do I find them?   faq707-1945 SkipVought 21 May 02 7.5 / 13
Working with binary data  faq707-6404 Bong 7 May 08 10.0 / 1
WORKSHEET CHECKBOX ALTERNATIVE   faq707-5378 BrainB 12 Aug 04 8.0 / 1
 

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close