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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:24 PM.