I would urge to to consider the use of a userform to gather the data. This is the most elegant approach and relatively simple to achieve. The values from the userform can be used to populate bookmarked locations, content controls or docvariables and their associated fields. The basics are covered at
http://www.gmayor.com/Userform.htm