Search
Hall of Fame
About Us
All Questions
New Question
Login
C#
VB
ASP.NET
XAML
WCF
LINQ
SQL
IIS
Excel
Word
Access
SharePoint
SQL
Windows 7
All 76 Topics
0
Replies
re: Compile error - wrong number of arguments or invalid property assignment
( 0 views ) Submitted By
John Wirth
on 30-Apr-13 06:41 PM in
Microsoft Excel
.
1
Reply
re: Compile error - wrong number of arguments or invalid property assignment
( 1 views ) Submitted By
John Wirth
on 29-Apr-13 08:22 AM in
Microsoft Excel
.
0
Replies
re: Compile error - wrong number of arguments or invalid property assignment
( 0 views ) Submitted By
John Wirth
on 29-Apr-13 08:12 AM in
Microsoft Excel
.
7
Replies
Compile error - wrong number of arguments or invalid property assignment
( 57 views ) Submitted By
John Wirth
on 28-Apr-13 08:13 AM in
Microsoft Excel
.
0
Replies
re: Delete word table if formfield in cell is blank
( 0 views ) Submitted By
John Wirth
on 23-Mar-13 01:17 PM in
Microsoft Excel
.
1
Reply
re: Delete word table if formfield in cell is blank
( 1 views ) Submitted By
John Wirth
on 23-Mar-13 05:58 AM in
Microsoft Excel
.
4
Replies
Delete word table if formfield in cell is blank
( 131 views ) Submitted By
John Wirth
on 22-Mar-13 08:01 PM in
Microsoft Excel
.
0
Replies
re: Compile error- argument not optional when controlling Word from Excel
( 0 views ) Submitted By
John Wirth
on 19-Mar-13 06:23 AM in
Microsoft Excel
.
0
Replies
re: Compile error- argument not optional when controlling Word from Excel
( 0 views ) Submitted By
John Wirth
on 18-Mar-13 06:49 AM in
Microsoft Excel
.
3
Replies
Compile error- argument not optional when controlling Word from Excel
( 132 views ) Submitted By
John Wirth
on 15-Mar-13 01:32 PM in
Microsoft Excel
.
1
Reply
Trigger code if comment added, deleted or edited
( 89 views ) Submitted By
John Wirth
on 09-Mar-13 03:41 PM in
Microsoft Excel
.
1
Reply
Excel names range values passed to a static variable
( 115 views ) Submitted By
John Wirth
on 27-Jan-13 12:09 PM in
Microsoft Excel
.
1
Reply
UserForm Hide instead of Unload Me when looping through documents
( 131 views ) Submitted By
John Wirth
on 22-Jan-13 04:56 AM in
Microsoft Word
.
0
Replies
Work through a series of open documents using VBA
( 119 views ) Submitted By
John Wirth
on 07-Jan-13 07:29 AM in
Microsoft Word
.
0
Replies
re: How do I disable the close button on spell check?
( 0 views ) Submitted By
John Wirth
on 06-Jan-13 03:00 AM in
Microsoft Word
.
0
Replies
re: How do I disable the close button on spell check?
( 0 views ) Submitted By
John Wirth
on 06-Jan-13 02:56 AM in
Microsoft Word
.
0
Replies
Changing the active document in a series of open documents
( 116 views ) Submitted By
John Wirth
on 11-Dec-12 05:31 PM in
Microsoft Word
.
0
Replies
re: Worksheet selection change causing code to run twice
( 0 views ) Submitted By
John Wirth
on 30-Nov-12 05:42 AM in
Microsoft Excel
.
2
Replies
Worksheet selection change causing code to run twice
( 184 views ) Submitted By
John Wirth
on 26-Nov-12 01:31 PM in
Microsoft Excel
.
1
Reply
re: Worksheet UDF not updating
( 1 views ) Submitted By
John Wirth
on 26-Nov-12 03:07 AM in
Microsoft Excel
.
0
Replies
Linked comments in a linked workbook
( 107 views ) Submitted By
John Wirth
on 20-Nov-12 05:01 AM in
Microsoft Excel
.
1
Reply
re: Worksheet UDF not updating
( 1 views ) Submitted By
John Wirth
on 20-Nov-12 04:55 AM in
Microsoft Excel
.
6
Replies
Worksheet UDF not updating
( 212 views ) Submitted By
John Wirth
on 16-Nov-12 07:36 AM in
Microsoft Excel
.
0
Replies
re: Remove entries from a combo box based on value in second column
( 0 views ) Submitted By
John Wirth
on 28-Oct-12 07:40 PM in
Microsoft Excel
.
0
Replies
re: Remove entries from a combo box based on value in second column
( 0 views ) Submitted By
John Wirth
on 28-Oct-12 07:40 PM in
Microsoft Excel
.
0
Replies
re: Remove entries from a combo box based on value in second column
( 0 views ) Submitted By
John Wirth
on 28-Oct-12 07:40 PM in
Microsoft Excel
.
4
Replies
Remove entries from a combo box based on value in second column
( 160 views ) Submitted By
John Wirth
on 28-Oct-12 09:17 AM in
Microsoft Excel
.
1
Reply
re: Code populates cell range, if not entered using enter, next cell clicked is also populated
( 1 views ) Submitted By
John Wirth
on 20-Oct-12 05:33 AM in
Microsoft Excel
.
0
Replies
re: Code populates cell range, if not entered using enter, next cell clicked is also populated
( 0 views ) Submitted By
John Wirth
on 19-Oct-12 04:14 PM in
Microsoft Excel
.
1
Reply
re: Code populates cell range, if not entered using enter, next cell clicked is also populated
( 1 views ) Submitted By
John Wirth
on 19-Oct-12 04:13 PM in
Microsoft Excel
.
0
Replies
re: Create one list to be used in multiple workbooks
( 0 views ) Submitted By
John Wirth
on 19-Oct-12 04:02 PM in
Microsoft Excel
.
7
Replies
Code populates cell range, if not entered using enter, next cell clicked is also populated
( 232 views ) Submitted By
John Wirth
on 19-Oct-12 03:31 AM in
Microsoft Excel
.
0
Replies
re: VBA- Applying value to range of cells not working if enter is pressed
( 0 views ) Submitted By
John Wirth
on 19-Oct-12 03:29 AM in
Microsoft Excel
.
1
Reply
re: VBA- Applying value to range of cells not working if enter is pressed
( 1 views ) Submitted By
John Wirth
on 16-Oct-12 05:38 AM in
Microsoft Excel
.
0
Replies
re: VBA- Applying value to range of cells not working if enter is pressed
( 0 views ) Submitted By
John Wirth
on 15-Oct-12 09:21 AM in
Microsoft Excel
.
0
Replies
re: VBA- Applying value to range of cells not working if enter is pressed
( 0 views ) Submitted By
John Wirth
on 15-Oct-12 07:57 AM in
Microsoft Excel
.
0
Replies
re: VBA- Applying value to range of cells not working if enter is pressed
( 0 views ) Submitted By
John Wirth
on 07-Oct-12 12:32 PM in
Microsoft Excel
.
8
Replies
VBA- Applying value to range of cells not working if enter is pressed
( 227 views ) Submitted By
John Wirth
on 07-Oct-12 08:20 AM in
Microsoft Excel
.
1
Reply
Value to selected range- VBA
( 202 views ) Submitted By
John Wirth
on 06-Oct-12 06:42 PM in
Microsoft Excel
.
0
Replies
Why does spell-check not check grammar on an unprotected form?
( 219 views ) Submitted By
John Wirth
on 10-Jul-12 04:45 PM in
Microsoft Word
.
0
Replies
re: Access Grammar Settings (Grammar & Style) through VBA
( 0 views ) Submitted By
John Wirth
on 10-Jul-12 04:44 PM in
Microsoft Word
.
0
Replies
re: Loop code for spell check mysteriously crashes at random
( 0 views ) Submitted By
John Wirth
on 05-Jul-12 06:40 PM in
Microsoft Word
.
2
Replies
Loop code for spell check mysteriously crashes at random
( 248 views ) Submitted By
John Wirth
on 05-Jul-12 07:16 AM in
Microsoft Word
.
5
Replies
How do I disable the close button on spell check?
( 291 views ) Submitted By
John Wirth
on 18-Jun-12 06:36 PM in
Microsoft Word
.
1
Reply
re: Looping through word documents problem
( 1 views ) Submitted By
John Wirth
on 24-Apr-12 05:39 PM in
Microsoft Excel
.
6
Replies
Looping through word documents problem
( 280 views ) Submitted By
John Wirth
on 18-Apr-12 01:07 PM in
Microsoft Excel
.
0
Replies
re: VBA SetAttr vbNormal problem with active document
( 0 views ) Submitted By
John Wirth
on 04-Apr-12 03:41 AM in
Microsoft Excel
.
1
Reply
re: VBA SetAttr vbNormal problem with active document
( 1 views ) Submitted By
John Wirth
on 03-Apr-12 03:18 PM in
Microsoft Excel
.
4
Replies
VBA SetAttr vbNormal problem with active document
( 261 views ) Submitted By
John Wirth
on 03-Apr-12 07:44 AM in
Microsoft Excel
.
0
Replies
re: Access Grammar Settings (Grammar & Style) through VBA
( 0 views ) Submitted By
John Wirth
on 26-Mar-12 03:08 PM in
Microsoft Word
.
3
Replies
Access Grammar Settings (Grammar & Style) through VBA
( 357 views ) Submitted By
John Wirth
on 22-Mar-12 06:35 AM in
Microsoft Word
.
0
Replies
re: Text from userform text box to form control vbCrLf squares
( 0 views ) Submitted By
John Wirth
on 18-Mar-12 02:24 PM in
Techniques/FAQ
.
2
Replies
Text from userform text box to form control vbCrLf squares
( 248 views ) Submitted By
John Wirth
on 18-Mar-12 10:03 AM in
Techniques/FAQ
.
3
Replies
Find and open word docs in an Excel list
( 236 views ) Submitted By
John Wirth
on 07-Feb-12 05:21 PM in
Microsoft Excel
.
2
Replies
Excel time value not recognised as time value
( 241 views ) Submitted By
John Wirth
on 30-Dec-11 04:13 PM in
Microsoft Excel
.
0
Replies
re: Make row number value a four digit number with preceeding zeros
( 0 views ) Submitted By
John Wirth
on 15-Nov-11 04:38 PM in
Microsoft Excel
.
5
Replies
Make row number value a four digit number with preceeding zeros
( 325 views ) Submitted By
John Wirth
on 15-Nov-11 08:36 AM in
Microsoft Excel
.
0
Replies
re: Cannot pass a value to a textbox when located in a frame on userform
( 0 views ) Submitted By
John Wirth
on 12-Nov-11 02:26 AM in
Microsoft Excel
.
1
Reply
re: Cannot pass a value to a textbox when located in a frame on userform
( 1 views ) Submitted By
John Wirth
on 12-Nov-11 02:24 AM in
Microsoft Excel
.
6
Replies
Cannot pass a value to a textbox when located in a frame on userform
( 364 views ) Submitted By
John Wirth
on 11-Nov-11 02:30 PM in
Microsoft Excel
.
0
Replies
re: Problem with applying number format using VBA
( 0 views ) Submitted By
John Wirth
on 17-Oct-11 03:57 AM in
Microsoft Powerpoint
.
2
Replies
Problem with applying number format using VBA
( 439 views ) Submitted By
John Wirth
on 13-Oct-11 03:37 AM in
Microsoft Powerpoint
.
1
Reply
VBA- evaluate if a date entered is not in the same month
( 410 views ) Submitted By
John Wirth
on 04-Oct-11 10:50 AM in
Expression Web
.
1
Reply
re: Get values from a named range and ignore any subsequent changes
( 1 views ) Submitted By
John Wirth
on 21-Sep-11 02:48 AM in
Microsoft Excel
.
0
Replies
re: Get values from a named range and ignore any subsequent changes
( 0 views ) Submitted By
John Wirth
on 20-Sep-11 07:24 AM in
Microsoft Excel
.
5
Replies
Get values from a named range and ignore any subsequent changes
( 391 views ) Submitted By
John Wirth
on 19-Sep-11 05:00 AM in
Microsoft Excel
.
1
Reply
re: On exit from combo VBA code works if fields in same frame selected.
( 1 views ) Submitted By
John Wirth
on 01-Aug-11 03:06 PM in
Microsoft Word
.
3
Replies
On exit from combo VBA code works if fields in same frame selected.
( 314 views ) Submitted By
John Wirth
on 01-Aug-11 07:57 AM in
Microsoft Word
.
0
Replies
re: VBA to confirm spelling ang grammar check has run
( 0 views ) Submitted By
John Wirth
on 01-Aug-11 06:03 AM in
Microsoft Word
.
1
Reply
Invalid property value & how to select last item in a combobox list.
( 222 views ) Submitted By
John Wirth
on 01-Aug-11 05:59 AM in
Microsoft Word
.
2
Replies
VBA to confirm spelling ang grammar check has run
( 482 views ) Submitted By
John Wirth
on 01-Jul-11 05:58 PM in
Microsoft Word
.
0
Replies
re: Count dates in 3 month period based on month in cell
( 0 views ) Submitted By
John Wirth
on 27-May-11 06:31 PM in
Microsoft Excel
.
4
Replies
Count dates in 3 month period based on month in cell
( 340 views ) Submitted By
John Wirth
on 27-May-11 07:54 AM in
Microsoft Excel
.
0
Replies
re: Error handler- how to continue running main code
( 0 views ) Submitted By
John Wirth
on 06-Apr-11 12:54 PM in
Microsoft Excel
.
0
Replies
re: Error handler- how to continue running main code
( 0 views ) Submitted By
John Wirth
on 06-Apr-11 11:44 AM in
Microsoft Excel
.
0
Replies
re: Error handler- how to continue running main code
( 0 views ) Submitted By
John Wirth
on 06-Apr-11 11:34 AM in
Microsoft Excel
.
4
Replies
Error handler- how to continue running main code
( 333 views ) Submitted By
John Wirth
on 06-Apr-11 09:31 AM in
Microsoft Excel
.
0
Replies
re: Paragraphs lost when populating cell from Word text form field.
( 0 views ) Submitted By
John Wirth
on 05-Apr-11 01:23 PM in
Microsoft Excel
.
1
Reply
re: Paragraphs lost when populating cell from Word text form field.
( 1 views ) Submitted By
John Wirth
on 05-Apr-11 12:16 PM in
Microsoft Excel
.
1
Reply
re: Paragraphs lost when populating cell from Word text form field.
( 1 views ) Submitted By
John Wirth
on 05-Apr-11 11:44 AM in
Microsoft Excel
.
0
Replies
re: Paragraphs lost when populating cell from Word text form field.
( 0 views ) Submitted By
John Wirth
on 05-Apr-11 11:32 AM in
Microsoft Excel
.
1
Reply
re: Paragraphs lost when populating cell from Word text form field.
( 1 views ) Submitted By
John Wirth
on 05-Apr-11 11:24 AM in
Microsoft Excel
.
0
Replies
re: Paragraphs lost when populating cell from Word text form field.
( 0 views ) Submitted By
John Wirth
on 05-Apr-11 10:57 AM in
Microsoft Excel
.
1
Reply
re: Paragraphs lost when populating cell from Word text form field.
( 1 views ) Submitted By
John Wirth
on 05-Apr-11 10:42 AM in
Microsoft Excel
.
0
Replies
re: Paragraphs lost when populating cell from Word text form field.
( 0 views ) Submitted By
John Wirth
on 05-Apr-11 10:35 AM in
Microsoft Excel
.
2
Replies
re: Paragraphs lost when populating cell from Word text form field.
( 2 views ) Submitted By
John Wirth
on 05-Apr-11 09:31 AM in
Microsoft Excel
.
0
Replies
re: Get Word document properties using an Excel macro/ vba
( 0 views ) Submitted By
John Wirth
on 04-Apr-11 11:34 AM in
Microsoft Excel
.
16
Replies
Paragraphs lost when populating cell from Word text form field.
( 367 views ) Submitted By
John Wirth
on 04-Apr-11 11:33 AM in
Microsoft Excel
.
3
Replies
Get Word document properties using an Excel macro/ vba
( 704 views ) Submitted By
John Wirth
on 04-Apr-11 08:50 AM in
Microsoft Excel
.
0
Replies
re: Suppress read only/ password dialogue box at open document
( 0 views ) Submitted By
John Wirth
on 24-Mar-11 03:07 PM in
Microsoft Word
.
2
Replies
Suppress read only/ password dialogue box at open document
( 436 views ) Submitted By
John Wirth
on 23-Mar-11 06:11 PM in
Microsoft Word
.
0
Replies
Ignore blank rows when populating word combobox from excel range
( 460 views ) Submitted By
John Wirth
on 16-Mar-11 04:33 PM in
Microsoft Word
.
1
Reply
re: VBA Useform compare text using Left function, need to ignore case
( 1 views ) Submitted By
John Wirth
on 14-Mar-11 12:16 PM in
Microsoft Word
.
3
Replies
VBA Useform compare text using Left function, need to ignore case
( 341 views ) Submitted By
John Wirth
on 14-Mar-11 08:32 AM in
Microsoft Word
.
0
Replies
Populate Word ComboBox from embedded Excel sheet
( 328 views ) Submitted By
John Wirth
on 08-Mar-11 07:30 AM in
Microsoft Word
.
0
Replies
Extract text from column in word table and add to combobox
( 308 views ) Submitted By
John Wirth
on 05-Mar-11 04:27 PM in
Microsoft Word
.
0
Replies
re: Word predictive picklist based on user input similar to Google search
( 0 views ) Submitted By
John Wirth
on 22-Feb-11 07:02 AM in
Microsoft Word
.
0
Replies
re: Word predictive picklist based on user input similar to Google search
( 0 views ) Submitted By
John Wirth
on 13-Jan-11 07:14 AM in
Microsoft Word
.
3
Replies
Word predictive picklist based on user input similar to Google search
( 395 views ) Submitted By
John Wirth
on 12-Jan-11 01:26 PM in
Microsoft Word
.
1
Reply
re: Method or data member not found error
( 1 views ) Submitted By
John Wirth
on 30-Dec-10 07:14 AM in
Microsoft Excel
.
1
2
Next
Last
ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!