|
|
|
|
#1
05-09-2017, 03:06 AM
|
|||
|
|||
Replace:
strResult = GetValue("The value to find", 6) With strResult = GetValue(YourUserForm.TextBox1.Text, 6) or however your userform and .TextBox1 might be defined. 
|
|
#2
05-09-2017, 04:57 PM
|
|||
|
|||
|
Cheers Greg.
Unfortunately when run most of the time now it gives an Invalid use of Null (Error 94), relating to the line: strID = Arr(0, iCols) The search value and Excel workbook meet the requirements so I'm not exactly sure where this is coming from.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Import from multiple word files into an Excel tale | asmanokhchi | Word | 1 | 04-21-2015 06:24 AM |
| need VBA to Transpose the Data from excel to word based on given criteria(status) | winmaxservices2 | Excel Programming | 1 | 12-19-2014 10:21 PM |
 Import data from Excel into Word
|
sb003848 | Word | 1 | 11-04-2014 06:30 PM |
| Import excel data in to SQL Server | DavidBrown | Excel | 0 | 08-08-2011 04:49 AM |
| Import Pics and Excel Data into PP? | jawillyams | PowerPoint | 0 | 03-13-2011 01:03 PM |
Windows 7 32bit 
Office 2016
Hybrid Mode