C# 操作Excel怎么把一个Cell设置成下拉框。

[wolma]

C# 操作Excel怎么把一个Cell设置成下拉框？就像在excel里设置数据有效性那样，设置几个候选值，然后再选中其中一个。
谢谢。

[wolma]

解决了，谢谢Jensel的提示 这是C#代码：
RSsheet = (Microsoft.Office.Interop.Excel._Worksheet)RSbook.Sheets.get_Item(1);
Range rng = (Range)RSsheet.Cells[1,1];
rng.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, XlFormatConditionOperator.xlBetween,"1,2,3", miss);
rng.Validation.InCellDropdown = true;
rng.Validation.IgnoreBlank = true;
rng.Value2 = "2";

[hyblusea]

录制宏,看一下他调用的方法及步骤

[龍月]

[Quote=引用 1 楼 hyblusea 的回复:]
录制宏,看一下他调用的方法及步骤
[/Quote]

c# 怎么搞宏

[hyblusea]

[Quote=引用 2 楼 ly_longyue 的回复:]
引用 1 楼 hyblusea 的回复:
录制宏,看一下他调用的方法及步骤


c# 怎么搞宏
[/Quote]

在Excel里面, 录制宏, 然后再将某列设置为下拉

[Jesenl]

Sub Macro1()
'
' Macro1 Macro
' 宏由 user 录制，时间: 2010-8-26
'

'
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="1,2,3,4"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.IMEMode = xlIMEModeNoControl
.ShowInput = True
.ShowError = True
End With
End Sub

[Jesenl]

Sub Macro1()
'
' Macro1 Macro
' 宏由 user 录制，时间: 2010-8-26
'

'
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="1,2,3,4"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.IMEMode = xlIMEModeNoControl
.ShowInput = True
.ShowError = True
End With
End Sub

[-小蕾-]

学习了，标记一下

[deyygywxf]

Sub Macro1()
'
' Macro1 Macro
' 宏由 user 录制，时间: 2010-8-26
'

'
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="1,2,3,4"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.IMEMode = xlIMEModeNoControl
.ShowInput = True
.ShowError = True
End With
End Sub

[wolma]

去试试Jensel给的代码。我看到C#里也有这些方法属性，只是不知道怎么用。