Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-31-2021, 02:37 AM
gmayor's Avatar
gmayor gmayor is offline Find&Replace multiple words in userform TextBox Windows 10 Find&Replace multiple words in userform TextBox Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default


Why are you even using a userform text box for this? Surely a combobox would make more sense? You could then have two columns in the list box, one for the number, the other for the description. You can choose whether or not to display the second column, if the users know what the numbers refer to. If you have the list in Excel, you can read the values into the listbox. See example attached. Save both items in the same folder for the list to work.
I also suggest using content controls rather than bookmarks as they are much less likely to be accidentally deleted. see
https://www.gmayor.com/insert_content_control_addin.htm
Attached Files
File Type: docm Example.docm (38.9 KB, 10 views)
File Type: xlsx List.xlsx (7.9 KB, 10 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find&Replace multiple words in userform TextBox Find and replace words according to excel file laith93 Word VBA 7 12-13-2021 08:11 PM
Userform textbox control missing/invisible; can't find, use or replace it; how to salvage work on a marceepoo Word VBA 8 05-01-2020 09:56 PM
Find&Replace multiple words in userform TextBox Find & Replace Multiple words Gartholameau Word VBA 2 01-20-2019 04:56 PM
Find&Replace multiple words in userform TextBox multiple find and replace in vba for special words kvnrao Word VBA 7 11-02-2018 06:28 PM
Find&Replace multiple words in userform TextBox Find and replace mutiple spaces between lowercase words only Dave T Word VBA 2 07-16-2015 11:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:03 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