#1
|
|||
|
|||
UserForm Formatting
Hi all
A little cheeky I know... In the attached Doc Template I have partially created a UserForm that serves as a questionnaire that users can employ to enter information and then submit it, ready-formatted, so that it can be used elsewhere. I have listed a couple of queries I have and cannot find the answers to. I am a complete novice as I know a few of you will quickly establish. Everything I have managed to do so far has been through scouring the web...but most of the info out there seems to refer ro Excel. If anyone can suggest improvements or resolutions to my specific queries I would be most humbly grateful. Thanks in advance Andy |
#2
|
||||
|
||||
Hi Andy,
There is no userform in your attachment - partly created or otherwise. Nevertheless, I have to ask why you're using a userform instead of a form document (ie a document with formfields)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Macropod
The reason is that I know nothing of Form Fields, so not sure whether they will fit the bill... I know that I'm using a sledgehammer to crack a nut... Basically users "can" complete this in the parent application straight off but some prefer to complete in Word so that it can be saved down, amended, spell checked etc. before pasting into the parent application, as once that is done the entry is locked and there is no way of ever amending it again, only viewing it. Also, if the entry is not completed within a certain time constraint the application auto closes and all inputted data is lost. I am simply trying to help myself and others in this respect by completing some kind of template so that they enter the data in the same way that they could do so in the parent application, then it is formatted ready to be pasted straight in...at least it allow for an element of checking without the threat of it disappearing before their eyes! Is this potentially unnecessary and creates "double handling"? yes of course! ...but people still input directly into Word from scratch, tinker with it, and then paste it on when happy...and hopefully I will learn something from creating something they can use... I have opened the attachment from this site and can view the UserFrom...although from my limited knowledge this may be because it is saved within a Project in Word on my machine...? Anyway I have included a couple of images of basically what I'm after, and the problems i'm currently having are displayed below... Fixes required. 1. The vertical scroll bar works on the Multipage Tool when inputting data. The window area cannot be expanded vertically when in Design Mode, to allow for the placement of further TextBoxes. 2. TextBox3 is formatted for Sentence Case capitals. How can this TextBox be formatted to show MONTH and WEEKDAY names i.e. SATURDAY, JULY in capitals. 3. If the text is deleted in TextBox3 it kicks in the debugger…must be something to do with the formatting above (point 2). 4. How can TextBox3 be formatted to allow for the <Return> button to created paragraphs. |
#4
|
||||
|
||||
Hi Andy,
Quote:
Having seen what you're trying to do, I'd suggest setting up the required 'fields' in an ordinary document using Word 2007's Content Controls. Unlike textbox fields on a userform, Rich Text Content Controls allow for carriage returns and, unlike formfields, support spell-checking. Best of all, no code is required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Oh well...never mind.
Thanks, |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Userform calls other userform, then populate worksheet | Lehoi | Excel Programming | 0 | 02-03-2016 02:58 PM |
Help with VBA userform | benn | PowerPoint | 1 | 03-02-2015 11:32 AM |
Keep Userform on Top | didjee | PowerPoint | 5 | 10-20-2014 02:22 PM |
VBA Code in a UserForm module to delete a Command Button which opens the userform | Simoninparis | Word VBA | 2 | 09-21-2014 03:50 AM |
Is it possible to take an input from a UserForm in one document to a UserForm in a do | BoringDavid | Word VBA | 5 | 05-09-2014 09:08 AM |