Validating User Input in Textbox [Form Control]

Dear All

I have a Textbox (Form Control) on a sheet that i wish to validate when the user changes the text. Specifically i wish to restrict entry to only numeric with a maximum of one decimal point. If this had been a Userform Textbox then i would used something like below.

I can find very little help on how to proceed when the textbox is a shape. I have to use the Form Control Textbox rather than just validating a cell as it is imperative that the textbox lays on top of corporate graphics in the sheet. In this instance the use of a userform is not appropriate.

Can anyone suggest a good resource for working with Form Control Textboxes, especially validation, or how i can proceed.

Please Login or Register  to view this content.

No the Textbox is not linked to a cell