×
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!
  • Students Click Here

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

Students Click Here

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 --
Managing Queries in Excel via MS Query  faq707-7934 SkipVought 29 Mar 18 --
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 19 Aug 18 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
 

Excel How To

Title :
Author :
Date :
24 Jun 05
Rating/# :
5.5 / 2

Title :
Author :
Date :
19 May 05
Rating/# :
6.2 / 5


Title :
Author :
Date :
2 Sep 05
Rating/# :
9.0 / 4

Title :
Author :
Date :
19 May 02
Rating/# :
5.6 / 8

Title :
Author :
Date :
28 Jun 07
Rating/# :
7.8 / 9

Title :
Author :
Date :
23 Mar 06
Rating/# :
5.5 / 2

Title :
Author :
Date :
11 Feb 09
Rating/# :
--

Title :
Author :
Date :
24 Mar 07
Rating/# :
8.4 / 25

Title :
Author :
Date :
23 Mar 06
Rating/# :
--

Title :
Author :
Date :
7 Jun 05
Rating/# :
10.0 / 1

Title :
Author :
Date :
15 Feb 06
Rating/# :
10.0 / 1

Title :
Author :
Date :
29 Apr 05
Rating/# :
9.0 / 1

Title :
Author :
Date :
8 Dec 06
Rating/# :
8.0 / 29

Title :
Author :
Date :
28 Nov 02
Rating/# :
8.5 / 13

Title :
Author :
Date :
19 Mar 02
Rating/# :
7.7 / 14

Title :
Author :
Date :
22 Aug 11
Rating/# :
--

Title :
Author :
Date :
4 Nov 03
Rating/# :
9.0 / 2

Title :
Author :
Date :
22 Sep 12
Rating/# :
--

Title :
Author :
Date :
29 Mar 18
Rating/# :
--

Title :
Author :
Date :
21 Aug 03
Rating/# :
9.5 / 4

Title :
Author :
Date :
19 Oct 04
Rating/# :
--

Title :
Author :
Date :
17 Dec 02
Rating/# :
5.7 / 3

Title :
Author :
Date :
16 Mar 05
Rating/# :
8.3 / 6

Title :
Author :
Date :
19 Jul 06
Rating/# :
--

Title :
Author :
Date :
6 Sep 06
Rating/# :
4.0 / 3

Title :
Author :
Date :
12 Aug 04
Rating/# :
2.5 / 2

 

Microsoft Word How To?

Title :
Author :
Date :
13 Dec 05
Rating/# :
--

Title :
Author :
Date :
11 Nov 01
Rating/# :
6.8 / 6

Title :
Author :
Date :
9 Jun 05
Rating/# :
--

Title :
Author :
Date :
20 Dec 11
Rating/# :
--

Title :
Author :
Date :
15 Jan 02
Rating/# :
8.7 / 3

 

Names Collection

Title :
Author :
Date :
23 Nov 00
Rating/# :
5.3 / 3

Title :
Author :
Date :
23 Nov 00
Rating/# :
5.7 / 6

Title :
Author :
Date :
12 Jul 01
Rating/# :
5.0 / 4

 

Office / VBA General

Title :
Author :
Date :
29 Sep 07
Rating/# :
--

Title :
Author :
Date :
12 Feb 04
Rating/# :
7.3 / 9

Title :
Author :
Date :
2 Oct 07
Rating/# :
--

Title :
Author :
Date :
23 Jun 04
Rating/# :
8.8 / 10


Title :
Author :
Date :
29 Oct 03
Rating/# :
10.0 / 1

Title :
Author :
Date :
15 Apr 04
Rating/# :
3.0 / 3


Title :
Author :
Date :
13 Oct 03
Rating/# :
8.6 / 7

Title :
Author :
Date :
27 Apr 06
Rating/# :
--

Title :
Author :
Date :
8 May 04
Rating/# :
8.3 / 21

Title :
Author :
Date :
25 Feb 04
Rating/# :
2.0 / 1

Title :
Author :
Date :
24 Nov 09
Rating/# :
2.0 / 1

Title :
Author :
Date :
7 Oct 03
Rating/# :
8.7 / 3

Title :
Author :
Date :
16 Jan 04
Rating/# :
9.3 / 4

Title :
Author :
Date :
5 Dec 03
Rating/# :
6.5 / 11

 

Outlook VBA

Title :
Author :
Date :
3 Mar 06
Rating/# :
--

Title :
Author :
Date :
10 Aug 04
Rating/# :
6.7 / 3

 

Powerpoint

Title :
Author :
Date :
23 Mar 06
Rating/# :
--

Title :
Author :
Date :
27 Mar 02
Rating/# :
9.0 / 2

Title :
Author :
Date :
23 Mar 06
Rating/# :
--

Title :
Author :
Date :
11 Feb 04
Rating/# :
6.0 / 3

Title :
Author :
Date :
23 Mar 06
Rating/# :
--

 

Presentation

Title :
Author :
Date :
5 Mar 02
Rating/# :
8.1 / 13


 

Protection

Title :
Author :
Date :
12 Apr 01
Rating/# :
8.6 / 10

 

VB Application w/ Outlook 2002

Title :
Author :
Date :
10 May 02
Rating/# :
7.3 / 7

 

VBA For Beginners

Title :
Author :
Date :
16 Feb 05
Rating/# :
6.5 / 25

 

VBA How To

Title :
Author :
Date :
29 Jun 04
Rating/# :
--

Title :
Author :
Date :
19 May 05
Rating/# :
5.8 / 5

Title :
Author :
Date :
26 Jan 04
Rating/# :
10.0 / 1

Title :
Author :
Date :
22 Jan 04
Rating/# :
--

Title :
Author :
Date :
5 Dec 12
Rating/# :
6.0 / 2

Title :
Author :
Date :
12 Oct 05
Rating/# :
--

Title :
Author :
Date :
10 Jun 04
Rating/# :
4.0 / 1

Title :
Author :
Date :
28 Aug 03
Rating/# :
6.6 / 7

Title :
Author :
Date :
29 Nov 05
Rating/# :
6.8 / 8

Title :
Author :
Date :
2 Apr 03
Rating/# :
9.5 / 2

Title :
Author :
Date :
29 Jun 04
Rating/# :
--

Title :
Author :
Date :
19 May 05
Rating/# :
3.7 / 3

Title :
Author :
Date :
4 Nov 02
Rating/# :
7.0 / 3

Title :
Author :
Date :
20 May 03
Rating/# :
7.5 / 2

Title :
Author :
Date :
8 May 04
Rating/# :
8.8 / 77

Title :
Author :
Date :
19 Aug 18
Rating/# :
8.5 / 33

Title :
Author :
Date :
19 Jul 07
Rating/# :
--

Title :
Author :
Date :
12 Jan 04
Rating/# :
7.9 / 13

Title :
Author :
Date :
19 Oct 07
Rating/# :
10.0 / 1

Title :
Author :
Date :
10 Sep 06
Rating/# :
10.0 / 5

Title :
Author :
Date :
9 Oct 14
Rating/# :
--

Title :
Author :
Date :
16 Dec 03
Rating/# :
6.3 / 13


Title :
Author :
Date :
7 Aug 03
Rating/# :
3.3 / 3

Title :
Author :
Date :
29 Jun 04
Rating/# :
--

Title :
Author :
Date :
12 Jan 06
Rating/# :
6.0 / 2

Title :
Author :
Date :
29 Jun 04
Rating/# :
5.0 / 2

Title :
Author :
Date :
8 May 04
Rating/# :
9.3 / 10

Title :
Author :
Date :
22 Dec 03
Rating/# :
9.8 / 5

Title :
Author :
Date :
4 Oct 02
Rating/# :
6.7 / 3

Title :
Author :
Date :
5 Aug 02
Rating/# :
4.6 / 5

Title :
Author :
Date :
20 Dec 03
Rating/# :
8.6 / 16

Title :
Author :
Date :
10 Jun 04
Rating/# :
--

Title :
Author :
Date :
19 May 05
Rating/# :
1.0 / 1

Title :
Author :
Date :
25 Aug 10
Rating/# :
1.0 / 1

Title :
Author :
Date :
22 Oct 03
Rating/# :
7.6 / 9

Title :
Author :
Date :
6 Nov 03
Rating/# :
8.8 / 11

Title :
Author :
Date :
28 Apr 04
Rating/# :
--

Title :
Author :
Date :
6 Jul 04
Rating/# :
--

Title :
Author :
Date :
13 Apr 04
Rating/# :
10.0 / 2


Title :
Author :
Date :
19 Sep 03
Rating/# :
7.3 / 4

Title :
Author :
Date :
23 Mar 04
Rating/# :
6.8 / 6

Title :
Author :
Date :
23 Mar 04
Rating/# :
6.0 / 4

Title :
Author :
Date :
23 Mar 04
Rating/# :
6.7 / 3

Title :
Author :
Date :
5 Apr 04
Rating/# :
9.5 / 4

Title :
Author :
Date :
29 Jun 04
Rating/# :
6.0 / 1

Title :
Author :
Date :
21 May 02
Rating/# :
7.5 / 13

Title :
Author :
Date :
7 May 08
Rating/# :
10.0 / 1

Title :
Author :
Date :
12 Aug 04
Rating/# :
8.0 / 1

 
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