Thread: [Solved] Template creation
View Single Post
 
Old 09-16-2014, 07:19 PM
Charles Kenyon Charles Kenyon is offline Windows 7 64bit Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I agree with Graham and would have recommended a userform but for your constraint of "without macros." These are much easier on the user. A problem with successive ASK or FILLIN fields is that if you make a mistake you probably have to start all over from the beginning. If you have very many questions to answer, it is a real pain.

A userform is a custom dialog box which can gather all the information you need in one go and which can be recalled to make corrections. It does, though, require vba (macros).
Reply With Quote