![]() |
|
|
|
#1
|
|||
|
|||
|
I want to search in all the tables
Multiple search (search input stored in a array). Want to msgbox like, With Selection If .Information(wdWithInTable) = False Then MsgBox "The cursor must be within a table cell.", , "Cursor outside table" Exit Sub Trial code for two input search Dim oText As String Dim oSrch As String Dim oRng As Range Dim oCell As Range Dim oTable As Table Dim oRow As Row Dim bText As Boolean Dim i As Long Set oTable = Selection.Tables(1) oText = InputBox(Prompt:="Enter the text", _ Title:="* Search Box *", _ Default:="") oSrch = InputBox(Prompt:="Enter BD No", _ Title:="* Search Box *", _ Default:="") For i = 1 To oTable.Rows.Count bText = False Set oRow = oTable.Rows(i) Set oRng = oRow.Cells(1).Range If InStr(1, oRng.Text, oSrch) > 0 Then Set oCell = oRow.Cells(4).Range oCell.End = oCell.End - 1 If Len(oCell) > 0 Then bText = True oCell.Collapse 0 If bText = True Then oCell.Text = Chr(32) & oText Else oCell.Text = oText End If End If Next i oSrch = InputBox(Prompt:="Enter 2nd BD No", _ Title:="* Search Box *", _ Default:="") For i = 1 To oTable.Rows.Count bText = False Set oRow = oTable.Rows(i) Set oRng = oRow.Cells(1).Range If InStr(1, oRng.Text, oSrch) > 0 Then Set oCell = oRow.Cells(4).Range oCell.End = oCell.End - 1 If Len(oCell) > 0 Then bText = True oCell.Collapse 0 If bText = True Then oCell.Text = Chr(32) & oText Else oCell.Text = oText End If End If Next i lbl_Exit: Set oTable = Nothing Set oRow = Nothing Set oCell = Nothing Set oRng = Nothing Exit Sub End Sub |
|
| Tags |
| array, search, table |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to search with column heading then doing the lookup action for below code | cmreddy.vba | Excel Programming | 0 | 01-20-2015 03:44 AM |
| VBA to search each row of a word table column | Marrick13 | Word VBA | 7 | 11-17-2014 04:33 AM |
Macro help - search for value, paste a value in another column
|
IRollman | Excel Programming | 1 | 01-14-2014 01:05 PM |
| Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |
Need to search a column for a macth and return a result from a third column
|
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |