Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2011, 06:59 AM
Andy2011 Andy2011 is offline UserForm Formatting Windows Vista UserForm Formatting Office 2007
Novice
UserForm Formatting
 
Join Date: Jul 2011
Posts: 9
Andy2011 is on a distinguished road
Default 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
Attached Files
File Type: docx Fixes required.docx (13.7 KB, 12 views)
Reply With Quote
  #2  
Old 07-23-2011, 11:45 PM
macropod's Avatar
macropod macropod is offline UserForm Formatting Windows 7 64bit UserForm Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 07-24-2011, 02:53 PM
Andy2011 Andy2011 is offline UserForm Formatting Windows Vista UserForm Formatting Office 2007
Novice
UserForm Formatting
 
Join Date: Jul 2011
Posts: 9
Andy2011 is on a distinguished road
Default

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.
Attached Images
File Type: jpg 001.jpg (86.5 KB, 11 views)
File Type: jpg 002.jpg (87.6 KB, 10 views)
File Type: jpg 003.jpg (89.9 KB, 9 views)
File Type: jpg 004.jpg (89.5 KB, 10 views)
File Type: jpg 005.jpg (81.7 KB, 11 views)
Reply With Quote
  #4  
Old 07-24-2011, 07:56 PM
macropod's Avatar
macropod macropod is offline UserForm Formatting Windows 7 64bit UserForm Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Andy,
Quote:
I have opened the attachment from this site and can view the UserFrom
There is definitely no userform attached to the document you posted. Indeed, being a docx file, there couldn't be one!

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]
Reply With Quote
  #5  
Old 07-25-2011, 09:34 AM
Andy2011 Andy2011 is offline UserForm Formatting Windows Vista UserForm Formatting Office 2007
Novice
UserForm Formatting
 
Join Date: Jul 2011
Posts: 9
Andy2011 is on a distinguished road
Default

Oh well...never mind.

Thanks,
Reply With Quote
Reply

Thread Tools
Display Modes


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
UserForm Formatting Help with VBA userform benn PowerPoint 1 03-02-2015 11:32 AM
UserForm Formatting 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
UserForm Formatting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft