Microsoft Excel - I WANT USE COMBOBOX IN EXCEL SHEET

Dear Sir,

Sir I have two sheets in excel, 1st sheet is data sheet where user save data and 2nd sheet is working sheet. for example in data sheet i have four column like Name, Age , City , hobby. In working sheet a combobox show all the names that stored in name column and and all data like city, age, hobby are getting in linked cell.
and also i want to protect that combobox settings that nobody can change my setting

thanks


Rajan

Hello Rajan,

The attached file contains a couple of manifestations of use of a combo-box - one a form and one a control.  The advantage of the control is that you can control the font and number of entries visible and it has auto select as you type.

I am not sure exactly what you mean by wanting to protect the combo-box.

combo.zip

Regards

Harry