StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POExcel macro to search for text then Popup box if found then display number of times word appears
primarykey
Id
17348708
data
AcceptedAnswerId
17349292
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-06-27T16:41:11.520
FavoriteCount
0
LastActivityDate
2013-06-27T17:11:32.653
LastEditDate
2018-07-09T18:41:45.953
LastEditorUserId
-1
OwnerUserId
2528787
ParentId
0
PostTypeId
1
Score
0
ViewCount
1206
LastEditorDisplayName
text
Body
<p>Can someone help me alter this code so that when it finds the word it will also display the number of times the word appears? Thanks!</p> <pre><code>Sub findtext() ' ' findrobot Macro ' Will find the word robot ' ' Keyboard Shortcut: Ctrl+t ' Dim found As Variant Set found = Sheets("Email").Cells.find("robot", Sheets("Email").Cells(1, 1), xlValues, xlPart) If (Not found Is Nothing) Then 'found MsgBox "Words Found =" & found, vbOKOnly, "Found" Else 'not found MsgBox "Sorry the text was not found please try again. Macro stopping" End If End Sub </code></pre>
Tags
<excel><excel-vba><vba>
Title
Excel macro to search for text then Popup box if found then display number of times word appears
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USmgrobins
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou'll probably need to loop with the `.FindNext` method. There should be several examples of how to use that here on StackOverflow. Check them out and you can try to adapt your code, or if you have trouble modifying, just revise your question to show what you found, what you have tried, and explain that it is not working as you expect.
  singulars
  PostPostId
  POExcel macro to search for text then Popup box if found then display number of times word appears
  UserUserId
  USDavid Zemens

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.