Insert input box into macro to allow user to choose multiple text entries

		Microsoft Office Forums > Microsoft Word > Word VBA
Insert input box into macro to allow user to choose multiple text entries

FAQ

Thread Tools

Display Modes

03-31-2014, 03:18 PM

macropod

Windows 7 32bit Insert input box into macro to allow user to choose multiple text entries

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Basically:

Code:

Dim TargetList, i As Long
TargetList = InputBox("Put list of terms to find here, separated by commas")
For i = 0 To UBound(Split(TargetList, ","))
  MsgBox Split(TargetList, ",")(i)
Next

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User input to a variable on the document	dsm1995gst	Word VBA	1	09-03-2013 03:43 PM
Replacing text with user input.?.?.?	brad1977	Word	3	11-20-2012 10:20 AM
Restricting User Input on a TextBox (and setting focus)	joatmon	Excel Programming	1	06-05-2012 03:01 PM
Macro to Insert Text Into Cells Having Multiple Lines	revans611	Excel Programming	4	10-24-2011 10:15 AM
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 12:54 PM.