![]() |
|
#5
|
||||
|
||||
|
The Private Sub FillBM is simply a means of writing a value into a named bookmark without destroying the bookmark. It is called from the first macro to set the values in three bookmarks according to the setting of the check box in the userform.
Basically it sets a range to the bookmarked range, writes a new value to the range, then resets the bookmark to the modified range. As the Function is marked 'Private' it must be in the same module as the macro that calls it. If you manually delete text, there is every possibility that you will also delete the bookmark. If you want to change the value in a bookmark, call the function with a new value FillBM BookmarkName, Value
__________________
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 |
| Problem opening Outlook Today. Error Message: Cannot display the folder. Cannot find this file. Veri | atwnsw | Outlook | 0 | 11-01-2015 05:05 PM |
| How to Display Arrow for Drop Down Lists in Message Body | hue2 | Outlook | 0 | 03-20-2015 12:24 PM |
| Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
| Option Button selected will display text | ksigcajun | Word VBA | 7 | 07-14-2014 09:31 AM |
| Display paragraph of text based on value selected in combo | WordWaza | Word | 0 | 08-09-2013 06:30 AM |