PDA

View Full Version : Forms, textboxes & labels



northernstar
09-10-2007, 10:11 AM
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
09-10-2007, 10:52 AM
How about posting a workbook that shows the pages and controls?

northernstar
09-10-2007, 02:34 PM
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
09-10-2007, 03:11 PM
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.