Generate a string only if textbox has been changed

		Microsoft Office Forums > Microsoft Word > Word VBA
Generate a string only if textbox has been changed

08-01-2021, 09:32 PM

Guessed

Windows 10 Generate a string only if textbox has been changed

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,185

That looks a lot simpler. If you are always adding the values as a new paragraph at the end of the document it could be even shorter

Code:

If Me.PNBox <> "Person Name" Then
  ActiveDocument.Range.InsertAfter vbCr & Me.PNBox & ", " & Me.DABox & ", " & Me.TABox
End If

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
How can I compare a string in a cell to another string?	Amitti	Word VBA	2	04-10-2017 07:35 PM
How to find all string within string.	PRA007	Word VBA	18	02-12-2016 08:11 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Display result in textbox based on the input of another textbox	scarymovie	Word VBA	5	05-16-2012 07:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 PM.