Adding a field limitation (0-1 only) to a Private sub inputbox prompt.

[Coachwooten]

Hello Excel Gurus,

You helped me piece this sub together in an earlier thread, now I'm back for more. Here is the sub:

Please Login or Register  to view this content.

My question is whether or not it is possible to add some sort of data entry limitations to the Target.Row, 7 = Inputbox entry. Instead of having the 'Syntax for percentages: .85 = 85%', I'd like it to return an error message if the user inputs a value outside of 0-1, and re-prompt them for an input.

Thanks for your help on this!!!

[Bob Phillips]

Something like

Please Login or Register  to view this content.

[Coachwooten]

That works - thank you!