View Single Post
 
Old 09-23-2018, 04:24 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You can replace the following line
StrFnd = "dog,cat,pig,horse,man"

with something along the lines of
StrFnd = InputBox("Type words separated by a comma","Title of box","dog,cat,pig,horse,man")
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia