Activex Textbox input output value as numeric

Hi Friends,

I am using Activex textbox for input, value of which is later on used in a calculation to generate the report.

- Can you please let me know how to restrict input in the text box as only decimal or whole numbers.
- Also output from the textbox is linked to a cell, which is giving the cell value as text, can you please tell me how to convert it to numeric.
- With one code can i control all the textbox in a workbook, with the above conditions.

Thanks & Regards,