To the best of my knowledge you can only write back to a singe cell at a time
using a textbox object. List boxes and combo boxes can display lists in a
multiple cell range, but they only return a result to a single. cell.

Do you have text boxes for each cell in the range A30 through I35? If
that's the case you might want to consider using Microsoft Forms for your
data entry needs.
--
Kevin Backmann


"Kim K" wrote:

I have located the linked cell option but the text box is overtop of several
cells, it is made to type comments in and text is set to wrap, but the linked
cell option remains blank, do I need to range these cells that fall
underneath the text box? ie the text box is overtop of A30 to
I35....................
--
Thanks,,
Kim


"Kevin B" wrote:

Open the CONTROL TOOLBOX toolbar and click on the DESIGN BUTTON. Right click
on the text box and select PROPERTIES. In the list of available properties
locate LINKED CELL and assign the cell that gets the value entered into the
text box.

Repeat for all textbox or combo box objects
--
Kevin Backmann


"Kim K" wrote:

I created a form with combo and text boxes on it. THe form is perfect except
typed info in the boxes does not print. I am assuming there is something I
need to add to the code or set from false to true, but not sure where to
look, any help appreciated.
--
Thanks,,
Kim