Hello,

I have a pivot table to where i want to control a field with macro. Specifically an input box that is dimmed as a string or integer. I have gotten this far but the problem is if the user types something into the input box that is not a valid field it overrides it. Basically how do I restrict a user from accepting anything into an input box that is not a number or how do I constrict it to a specific list in a table.

Thanks