![]() |
|
#1
|
|||
|
|||
![]()
Have created so far two User Forms. They both work the way I want them, so far, but there are options a user can select. In one User Form there are 6 options. I have used bookmarks in my document instead of docvariables in the VBA (not sure which one would work better for my form in this instance).
If the user selects only option 1 and 6 then that leaves a big space. I would like that spacing to close up automatically. I have used the Help feature and found the Paragraphs.OpenOrCloseUp method but I must be entering something wrong, or not understanding their example, because nothing is closing up. Any information is appreciated. |
#2
|
|||
|
|||
![]()
Are your six bookmarks each defined in there own empty paragraph so that when done with your example above you have four empty bookmarks defined in four empty paragraphs?
OpenOrCloseUp is used to toggle space after paragraphs between 0 and 12 points. It does not delete empty paragraphs. You could define one bookmark in one empty paragraph and then define your option output in a single string variable and write it to the single bookmark. |
#3
|
|||
|
|||
![]()
yes, my bookmarks are in a separate line paragraph leaving empty bookmarks.
I will try the defining one bookmark in one empty paragraph and then define option output in a single string variable to the single bookmark. Thanks. |
#4
|
|||
|
|||
![]()
Thanks. That worked and this will help with other forms I am creating. Have a few more add ins to the user form and hopefully I can get them working the way I want.
Thanks again. |
#5
|
|||
|
|||
![]()
Glad to help.
|
![]() |
Tags |
close paragraphs, user forms |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
User form | abdulgani | Excel | 0 | 12-15-2014 05:54 AM |
Help with macro to save / email / close form | barters1972 | Word VBA | 1 | 04-20-2014 06:44 PM |
![]() |
mkellar | Word | 1 | 03-22-2013 10:10 PM |
Word 2003 form fields and pasting multiple paragraphs. | mwmoron | Word | 1 | 12-07-2012 11:06 PM |
![]() |
placasse47 | Excel Programming | 3 | 08-01-2012 05:57 AM |