Databases
StackOverflow2013
Postsdbo
PORange Validator in Excel with custom message text
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORange Validator in Excel with custom message text
    primarykey
    data
    text
    <p>I have the following code to give a Excel cell Validation with custom text.</p> <pre><code>var cellValues = activeSheet.Range[columnLetterValue + startingRow, Type.Missing]; cellValues.Validation.Add(XlDVType.xlValidateCustom, XlDVAlertStyle.xlValidAlertInformation, XlFormatConditionOperator.xlBetween, cellValues.Value2, Type.Missing); cellValues.Validation.IgnoreBlank = true; cellValues.Validation.ErrorTitle = "Custom error title"; cellValues.Validation.ErrorMessage = "Custom error message description"; cellValues.Validation.ShowError = true; cellValues.Validation.ShowInput = false; </code></pre> <p>When debugging the line to set the ErrorTitle or ErrorMessage a <code>'System.Runtime.InteropServices.COMException'</code> is thrown.</p> <p>Stacktrace:</p> <blockquote> <p>{System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC at<br> System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&amp; msgData) at<br> Microsoft.Office.Interop.Excel.Validation.set_ErrorTitle(String )</p> </blockquote> <p>I have looked online and found a couple of examples that show this is possible: <a href="https://stackoverflow.com/questions/3317307/range-validation-with-excel-using-c-sharp">Range Validation with Excel using C#</a></p> <p>I've even recorded a Macro in Excel and it works with the "VBA" equivilent code:</p> <pre><code> ActiveCell.FormulaR1C1 = "Custom" Range("A1").Select With Selection.Validation .Delete .Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertInformation, _ Operator:=xlBetween, Formula1:="Custom" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "UDF Title" .InputMessage = "" .ErrorMessage = "The message" .ShowInput = False .ShowError = True End With End Sub </code></pre> <p>I've also tried different combinations of XlDVType and XlFormatConditionOperator but that didn't seem to make any difference in setting the custom messagebox text.</p> <p><strong>Does anyone know how to set a Validation rule with custom ErrorTitle and ErrorMessage?</strong></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJeremy Thompson
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThis works for me in C# 2010 and Excel 2010. I can run your code as shown above, with the only difference that I set CellValues to ExcelApp.ActiveSheet.Range["A1"]. It adds the custom messages. I can do things to make it fail on the long Validation.Add line, like having a blank in A1, but can't make it fail on either the error message or error title line. One note, when you get it running you should probably include the Validation.Delete line, or you'll get runtime errors if you try to set it a second time.
      singulars
      1. PORange Validator in Excel with custom message text
      1. USDoug Glancy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload