Microsoft Excel - sir, i want use combobox in excel for getting detail from other sheet of excel

Asked By Rajan on 16-Nov-12 04:13 AM

Sir,

I want i select a name from combobox and excel getting all detail of that person like age, city, phone no. etc. in predefine cells from other presaved data sheet and also i want to use a check that no duplicate value will be entered in data sheet. how i will do this .

regards

rajan

Harry Boughen replied to Rajan on 25-Nov-12 09:34 PM

Hello Rajan,

Not sure if your combo box question is the same as your later one.

For preventing duplicate entries you can use the following procedure - you can use the whole column ($A:$A) if that suits better.

Select the range of cells in which you want to prevent
duplicates (for example, A1:A50).

From the Data menu select Validation.

Click on the Settings tab.

From the Allow dropdown box select Custom.

In the formula box type =COUNTIF($A$1:$A$50,A1)=1

Click on the Error Alert tab.

In the Title box type "Duplicate Entry!"

In the Error Message box type "You cannot enter a value
already in the list."