Excel 如何用VBA实现单元格有效性下拉菜单
发布网友
发布时间:2022-05-14 02:08
我来回答
共1个回答
热心网友
时间:2022-07-14 10:54
With [b1].Validation '生成数据有效性下拉菜单 【b1】为指定单元格
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=x ’x为有效性菜单格式为:A,B,C,D
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.IMEMode = xlIMEModeNoControl
.ShowInput = True
.ShowError = True
End With