Need Help With Form

[Yellowstone]

I am trying to create a form on an Excel worksheet that already has data on it. I want to be able to enter a range designated by the user that will calculate a percentage of filled cells (letters not numbers) to empty cells in the given range.
I was trying a COUNTA and COUNTBLANK type code but first time using a form and having trouble.

Example: If I have Data throughout B243:B394 and the User enters B256 and B301 I would like the form to calculate the percentage of cells with data in it to ones that are empty.

Will take any help available.
Thanks.

 

[Legacy 146544]

This might not be the prettiest of all but u could use a for next structure that will count each cell in the specified range that is not empty. Then divide the counted number by the total number of cells. Is this what you mean?


Something like this:
Dim acell as range
Dim counter1 as integer
For each acell in range
if acell.value <> ""
counter = counter + 1
end if
counter2 = counter2 + 1
Next acell