maybe you could use a combobox with a dropdown pointing to the rowsource
with your data. also, maybe you could use data validation in the cell the
textbox was going to fill.

just some thoughts, didn't test anything
--


Gary


"Soniya" wrote in message
ups.com...
Hi All,

How we can restrict only time with ten minutes interval are entered
into a text box?
Is it possible to acheive this using mode function?

i want only 0.0,0.1,0.2,0.3,0.4,0.5,1.0,1.1,1.2, etc to be entered in
the text box

TIA
Soniya