Excel 97 Combo Box Questions

  • Thread starter Thread starter Romy
  • Start date Start date
R

Romy

Hope someone can help me-- I have limited familiarity with Visual basic
so bear with me...

I'm making a workbook with about 15 sheets. On each sheet, I have
column in which each cell requires a drop-down list from which t
choose one phrase (out of about 15 possible phrases). I tried usin
Validation to do this, but I ran out of space and was unable to typ
any more after about 7 phrases. Who knew?? Anyway, I figured out ho
to link a combo box to one final sheet in my workbook, which I'll hid
from view when completed. So far, all is good.

Now, my questions: I'n tried making combo boxes from both the form
and the control toolbox toolbars, and have had success making an
copying single boxes. But what I'd really like to do is make one comb
box, and then paste it into each cell in the column I've designated o
each sheet for this purpose. This seems like it should be possible
since the combo box doesn't contain any conditional formula-- th
"ListFillRange" will be the same for each. Pasting in each one is
real pain. Also, how do I get the combo box to become linked to th
cells in which I paste them? I don't like the fact that they can jus
be dragged around-- I need to hand this workbook over to someone, an
need to make sure combo boxes with selections don't get moved about
and continue to line up properly with other cells in the row/column.
Know what I mean? I want them to resize with the cell as needed.

Sorry for the length of this. Don't know if this is possible to do-
if anyone knows how to be able to enter more into the Validation blank
I'd be happy with that solution since I could paste it so easily! MAN
THANKS!!
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Romy,

Stick to Data Validation. Put the possible values in a worksheet list, name
that list, and refer to that name in your DV.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top