ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box (https://www.excelbanter.com/excel-discussion-misc-queries/136625-combo-box.html)

JonathanW

Combo Box
 
I want to create a combo box that has different paper sizes i.e. A4,A5, DL
size etc. and when someone selects say A4 size in the combo box it then puts
it data 297
in a cell D1 and 210 in E1. I don't want there to be formulas in those two
cells, because I want people to be able to input custom sizes. Hence in the
combo box I want a 'custom size' option that deletes data in in cells DL and
E1 allowing them to enter their size of choice manually.
So I am assuming I'll need to do this with code?


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com