help: drop down list

[vcobra57]

hi,

i created a dropdown list using data validation. for example the lis
gives me 10 options to select from. after i select an option i woul
like to add a number at the end of my selection. not in a differen
cell. is there any way i can add text or numeric to the end of m
selection.

thanks for you help

 

[Frank Kabel]

Hi
only with VBA. See:
http://www.contextures.com/excelfiles.html#DataVal

and look for: Data Validation "Columns"

 

[vcobra57]

frank, thanks a million. that's what i needed