How to create validation range from value that input by user?

Question

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".

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

I'm not sure, I have installed only .NET Framework 3.5

Anonymous
– Anonymous

2010-03-23 04:31:06 +00:00
Commented Mar 23, 2010 at 4:31 — Anonymous
– Anonymous, Commented Mar 23, 2010 at 4:31

Todd Main · Accepted Answer · 2010-03-23 05:08:24Z

2

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"); 
}

answered Mar 23, 2010 at 5:08

Todd Main

29.2k11 gold badges85 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create validation range from value that input by user?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related