Hi,
We have an event and need to change the font. But using .size is not working. Any ideas?
With refRg.Validation
.Delete
.Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator:=xlBetween
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = txt
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
'.Size = 15
End With
We have an event and need to change the font. But using .size is not working. Any ideas?
With refRg.Validation
.Delete
.Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator:=xlBetween
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = txt
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
'.Size = 15
End With