No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi Using VB.NET I created an excel sheet with list of items in dropdownlist. Using the below code With xlWorksheet.Range("A2", "A101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:=[COLOR="Red"]"Construct,Testing,Review,Look Ahead Meetings,Process Audit,Process Improvement,Project Monitoring and control,Project Planning,Project Setup,Project Team Management,RCA Activities,Re-Estimation,Review,Review-Rework,Senior Management Reviews, Testing,Testing Rework,Training, Work Product Audit"[/COLOR]) End With But i can able …
|