Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-16-2014, 12:38 PM
fumei fumei is offline Insert input box into macro to allow user to define search term Windows 7 64bit Insert input box into macro to allow user to define search term Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

Code:
 .Text = InputBox("Type City and press Enter.")


Comments:
declare your variables!
if the Selection point is ahead of the text you enter, it will NOT find it. If you want to go through the entire document use the document range, rather than Selection.

Do you actually want to create a new document for every found instance of your text string?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert input box into macro to allow user to define search term Insert input box into macro to allow user to choose multiple text entries Hoxton118 Word VBA 6 04-03-2014 12:12 AM
Insert input box into macro to allow user to define search term User input to a variable on the document dsm1995gst Word VBA 1 09-03-2013 03:43 PM
Insert input box into macro to allow user to define search term Replacing text with user input.?.?.? brad1977 Word 3 11-20-2012 10:20 AM
Insert input box into macro to allow user to define search term Restricting User Input on a TextBox (and setting focus) joatmon Excel Programming 1 06-05-2012 03:01 PM
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft