I've been using drop down boxes (or list) boxes in several of my
spreadsheets to help with data input. I need to copy data entered
including the drop down box selection into another spreadsheet or into
MS Word.

I can't figure out how to copy the drop down selection.

Thoughts?

P.S. I don't program in visual basic. Thanks!


--
scottrichards7
------------------------------------------------------------------------
scottrichards7's Profile: http://www.excelforum.com/member.php...o&userid=27421
View this thread: http://www.excelforum.com/showthread...hreadid=469378

I created a drop down box recently in one cell and just copied the cell down
like I'd copy any cell. The drop down was copied with it.

"scottrichards7"
<scottrichards7.1vopeb_1127264702.8825@excelforu m-nospam.com wrote in
message news:scottrichards7.1vopeb_1127264702.8825@excelfo rum-nospam.com...

I've been using drop down boxes (or list) boxes in several of my
spreadsheets to help with data input. I need to copy data entered
including the drop down box selection into another spreadsheet or into
MS Word.

I can't figure out how to copy the drop down selection.

Thoughts?

P.S. I don't program in visual basic. Thanks!


--
scottrichards7
------------------------------------------------------------------------
scottrichards7's Profile:
http://www.excelforum.com/member.php...o&userid=27421
View this thread: http://www.excelforum.com/showthread...hreadid=469378