Create a Form in Excel

[dab1477]

Thanks in advance for the assist.

I am unable to use the Data/Form menu due to the number of
fields exceeding 32. Although I have > 32 fields, not all
are inputs. I'd like to create a form that allows me to
input to 28 of these fields, but have the ability to view
the entire sheet of 37 fields - the balance of the fields
are all computations.

How do I create a form or alter my sheet such that I am
able to use a form to input the 28 fields yet see all 37
fields as a result of my input.

dab1477

 

[Debra Dalgleish]

You could try John Walkenbach's Enhanced Data Form. It's free, and has
unlimited fields.

http://j-walk.com/ss/dataform/index.htm

If you need to modify it, you can purchase the password to the VBA code
for a reasonable fee.

 

[dab1477]

Thanks Debra. That's what I needed. Once again, this
group comes through.