Ooooh Noooo! I don't think you're being a jerk...I understand what you're saying...no worries.... the flow chart may not make sense to you or anyone else because you can't actually see the data I'm working with and also I'm just testing these macros not really expecting them to function to...
Sort of...I want when it the user inputs a word the cells are highlighted like in this code:
Sub find_highlight()
Dim W As String, rng As Range
W = InputBox("What to find?")
For Each rng In ActiveSheet.UsedRange
If rng.Value = W Then
rng.Select...
I want to ask if the word is spelled correctly because the data may have acronyms (e.g., BLT, KSC etc..) which appear to be misspelled words when in actuality they are just acronyms and is spelled correctly.
My hope was to make the search box code smarter in that it will prompt a msgbox if the user tried to search for a misspelled word. Earlier you mention that it was only possible with hard coding the macro. Well I will settle for an example of that ....I'm learning this VBA stuff. Thanks.
Search...
I don't think I asked the right question earlier. I have this search box that when I enter the search criteria it will find the row in sheet 2 and return the results in sheet 1 in a list. However, I want that if I enter a misspelled word in the search box and submit a msgbox will appear and ask...
I have this search box in excel, the macro will search through the spreadsheet for the entered text. Is it possible to have the search box act like Google with AutoCorrectEntries?
Excellent observation and I understand your logic but for now I just want it to find this criteria:
The msgbox would look something like:
"The adjacent word to "broken" is "pipe" . The word "pipe" is found "10" times!"
"The adjacent word to "broken" is "switch". The word "switch" is found...
If I wanted to search the next line of text should I add a loop to start a new search for the next word?
For example, the sentence is:
The HQ building has a broken pipe underneath the first floor. The main building has a broken switch in the hallway on the second floor. The ladies restroom...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.