Creating a drop-down list box

[ryanmc]

Hello,

I'm trying to create a drop-down list box in MS Excel and I'm not sure how to do this. I realize this is the MS Access forum, but I'm not getting any help in the MS Office forum, so I thought I ask here. I know there are some pretty smart people in this forum and I was hoping someone might be able to assist me.

Thanks,
Ryan.

 

[SIG357]

Are you trying to place a list box IN an excel spreadsheet, or are you working with UserForms?

 

[ryanmc]

Yes ... I am trying to place a list box in a spreadsheet. I've activated my Control Toolbox toolbar and I see there is the option of creating a drop-down list box, but I don't know how to populate it.

Ryan.