ExcelBanter - Coping Format Control input range to other picklists

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Coping Format Control input range to other picklists - HELP!! (https://www.excelbanter.com/excel-discussion-misc-queries/208055-coping-format-control-input-range-other-picklists-help.html)

tibby

Coping Format Control input range to other picklists - HELP!!

I have a spreadsheet with 1000 picklists for a report.

I would like to copy the input range from one Format Control - input range
to all the other picklists.

Is there any way to do this without opening every Format Control and copy
paste my input range into the field?

HELP!

All times are GMT +1. The time now is 04:11 PM.