Convert a cell to a listbox

BMD

Board Regular
Joined
Oct 5, 2005
Messages
211
How do you convert a cell like C1 to a list box of three things. Also can said list box be copied to the next row if other cells are added to the row and be blanked out in the new row and allow the user to pick a different one for each row?

Bruce.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Bruce

I don't think you really can convert a cell to a listbox.

What do you actually mean?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
You can use Data|Validation.

Then from Settings tab, select List from the Allow drop down.

In the source box, enter the 3 values separated by commas.

Once done. You can copy and Paste|Special Validations to other cells.

Is this what you mean?


Edit: Norie, we meet again :biggrin: on the happier Excel forum :LOL:
 

BMD

Board Regular
Joined
Oct 5, 2005
Messages
211
NBVC,
Thanks,,, Works Grate.....
Just what I wanted
Bruce.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Bruce

Glad that worked, bit that ain't no listbox.:)

It's a dropdown/combobox/whatever.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,796
Messages
5,574,361
Members
412,589
Latest member
ArtBOM
Top