I have created a workbook template that will be used to collect some data from users.
I want to restrict user input to numbers between 0 and 20 in each worksheet range A1:C5 (say).
I know I can use a Macro like below to do it
With oSheet Dim r As Integer = ds.Tables("tblStudents").Rows.Count + 1 Dim UsedRange As Excel.Range = .range("F2:K" & r) For Each cell In UsedRange If cell.Value < 0 or cell.Value > 20 Then MsgBox(" Out of range") cell.Value = "" End If Next End With
How can I include this macro to each worksheet when creating the workbook in my VB code.