I have the task of recreating a form in a specific format. It is a
fill-in-the-blanks on-screen (not on-line). I am pretty much a newbie
at form creation and have very little experience with VBA but with
decent instructions I'm willing to try anything. The form creation is
going fairly well, but the problem is that the person who has asked me
to do this is absolutely dead set on there being a text box in the
center of page one, which is a fixed size, and which is then linked to
a text box on a second page in case the discussion runs over the max
fixed size of the text box on page one. Before and after the text box
on page one are several boxes to click and insert short pieces of
information. This form must be protected so the inexperienced user
cannot inadvertently change the format.
My problem arises from the conflicting need to protect the form and to
have (linked) text boxes. I have split the form into four section,
and have protected sections 1 & 3 only, but after protection is on,
cannot type in the text box. The only reason I am using text boxes is
the need to have text flow from the middle of page 1, past the next
section of fill-in-the-blanks, to the linked text box on page 2. If
there is any other way to do it, I haven't yet figured it out. HELP?
(and remember I am very new to VBA).
fill-in-the-blanks on-screen (not on-line). I am pretty much a newbie
at form creation and have very little experience with VBA but with
decent instructions I'm willing to try anything. The form creation is
going fairly well, but the problem is that the person who has asked me
to do this is absolutely dead set on there being a text box in the
center of page one, which is a fixed size, and which is then linked to
a text box on a second page in case the discussion runs over the max
fixed size of the text box on page one. Before and after the text box
on page one are several boxes to click and insert short pieces of
information. This form must be protected so the inexperienced user
cannot inadvertently change the format.
My problem arises from the conflicting need to protect the form and to
have (linked) text boxes. I have split the form into four section,
and have protected sections 1 & 3 only, but after protection is on,
cannot type in the text box. The only reason I am using text boxes is
the need to have text flow from the middle of page 1, past the next
section of fill-in-the-blanks, to the linked text box on page 2. If
there is any other way to do it, I haven't yet figured it out. HELP?
(and remember I am very new to VBA).