Forms, textboxes & labels

[northernstar]

hi everyone

i have created a form with multipages and i would like to combine the values (a number and some text) into either one label or textbox on another page

also i would like to compare the values (numbers) in some textboxes to see if they fall within the set limits

for example the value maybe -0.34% and the limites are ?0.25% therefore i would like to highlight this with a * and perhaps change the colour of the box to red

would really just like some help in entering formulae into forms if possible

many thanks

[Bob Phillips]

How about posting a workbook that shows the pages and controls?

[northernstar]

i could post my file but dont think it would help as its in the very early stages
i have solved the orginal problem

but how can i apply data validation to a textbox

thanks

[Bob Phillips]

You can't, DV applies to input in a cell, and a textbox in its very definition ain't a cell. You would have to test the input in code.