This bit of code will count how many formulas you have used in a workbook, will display a message box of the count and the workbook name! Enjoy! Sub FormulaCount() Dim ws As Worksheet Dim rCheck As Range Dim lCount As Long On Error Resume Next For Each ws In Worksheets Set rCheck = Nothing […]
Number of rows for Open text list
This is how to set the number of rows required by using a numberic field within the survey. Question 1 – open number field – Ask fior the number of something required Question 2 – open text list Question 2 – Masking – nset(f(‘Question1’).get()) Question 2 – Trigger – Question1 Once the number is entered […]