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).
|