如何根据用户输入的值创建验证范围? [英] How to create validation range from value that input by user?

问题描述

我想在单元格"A1"中创建一个验证范围.该验证允许用户输入从1到x的值，而x表示用户在"B1"中输入的值.例如，如果用户在"B1"中输入值100，那么我们只能在"A1"单元格中输入1到100.

I want to create a validation range in cell "A1". This validation allow user to input value from 1 to x, while x refer to value user input in "B1". For example, if user input value 100 in "B1" then we can input only 1 to 100 in cell "A1".

我想知道如何在C#中做到这一点?

I want to know how to do this in C#?

推荐答案

假设您具有互操作性，则如下所示.请注意xlValidateWholeNumber，可以将其更改为xlValidateDecimal(以下的Formula1必须为小数)，以十进制表示.

Assuming you have interop, it would be like the below. Note xlValidateWholeNumber, that can be changed to xlValidateDecimal (and the subsequent Formula1 below would need to be a decimal) for decimals).

private void SetValidationBetweenNumbers() 
{ 

    Microsoft.Office.Tools.Excel.NamedRange cellThatNeedsValidating = 
        this.Controls.AddNamedRange(this.Range[""A1"", missing], 
        "cellThatNeedsValidating"); 

    cellThatNeedsValidating.Validation.Add( 
        Excel.XlDVType.xlValidateWholeNumber, 
        Excel.XlDVAlertStyle.xlValidAlertStop, 
        Excel.XlFormatConditionOperator.xlBetween, "1", "=B1"); 
}

这篇关于如何根据用户输入的值创建验证范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！