![]() |
|
|
|
#1
|
||||
|
||||
|
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
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
|
Gartholameau | Word VBA | 2 | 01-20-2019 04:56 PM |
multiple find and replace in vba for special words
|
kvnrao | Word VBA | 7 | 11-02-2018 06:28 PM |
Find and replace mutiple spaces between lowercase words only
|
Dave T | Word VBA | 2 | 07-16-2015 11:23 PM |