How can we get a range of cells to have a combo box
property? I have been told you can make a range of cells
(say A1 - A15) that are individual cell-type combo boxes.

I can't find anything when searching posts, and HELP only
gives me an individual combo box that I have to copy/paste.

Suggestions?

Thanks!

Duane,

You could select them al and apply Data Validation.

--

HTH

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

"Duane" wrote in message
...
How can we get a range of cells to have a combo box
property? I have been told you can make a range of cells
(say A1 - A15) that are individual cell-type combo boxes.

I can't find anything when searching posts, and HELP only
gives me an individual combo box that I have to copy/paste.

Suggestions?

Thanks!

Bob,

When I do that, I am told I can't use a range of cells
(the basis for the use of a combo box). Am I missing
something? Plus, that doesn't seem to give me a combo box
in any cell, let alone a range of cells.

I must not be understanding what you have said to do.

Thanks,

Duane


-----Original Message-----
Duane,

You could select them al and apply Data Validation.

--

HTH

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

"Duane" wrote in
message
...
How can we get a range of cells to have a combo box
property? I have been told you can make a range of
cells
(say A1 - A15) that are individual cell-type combo
boxes.

I can't find anything when searching posts, and HELP
only
gives me an individual combo box that I have to
copy/paste.

Suggestions?

Thanks!


.

Bob,

THANKS! It worked, when I select the right options.

We appreciate your help!

Duane, et. al



-----Original Message-----
Duane,

You could select them al and apply Data Validation.

--

HTH

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

"Duane" wrote in
message
...
How can we get a range of cells to have a combo box
property? I have been told you can make a range of
cells
(say A1 - A15) that are individual cell-type combo
boxes.

I can't find anything when searching posts, and HELP
only
gives me an individual combo box that I have to
copy/paste.

Suggestions?

Thanks!


.

Great, before I had a chance to respond<VBG.

Bob

wrote in message
...
Bob,

THANKS! It worked, when I select the right options.

We appreciate your help!

Duane, et. al



-----Original Message-----
Duane,

You could select them al and apply Data Validation.

--

HTH

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

"Duane" wrote in
message
...
How can we get a range of cells to have a combo box
property? I have been told you can make a range of
cells
(say A1 - A15) that are individual cell-type combo
boxes.

I can't find anything when searching posts, and HELP
only
gives me an individual combo box that I have to
copy/paste.

Suggestions?

Thanks!


.