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!

Not very clear on your requirement but without VBA:

Use a section of your sheet for the lists that the drop boxes use -
and then when you print/copy you can have full list and the selection will
be in the cell with the box.

" wrote:

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!

Hi
click the "design mode" icon in the control tool box. So you will enter
the design mode. then gp to the list box button. Right click. Select
properties. In the properties window, select linked cell. Give the
address of the cell you want the data to be copied (e.g. "B1"). Now you
can record a macro and do wahtever you want. It will automatically be
recorded. Hope this will help you.

Best.

T


--
twinklejmj
------------------------------------------------------------------------
twinklejmj's Profile: http://www.excelforum.com/member.php...o&userid=27085
View this thread: http://www.excelforum.com/showthread...hreadid=469057