code lines for user form.

[santosh226001]

friends pls help me for my following problem

we have a sheet where road details exit in this sheet we want some summery in a userform which one disply on sheet open

We make user form but can't define codelines pls help me

Total Nos of Roads : (heare we want in from nos of roads count in Roadlist sheet in colum A)

Nos of Roads Enterd : (heare we want in from nos of roads count in Roadlist sheet in colum I Which one mention "Enter")

Pending No of Roads to be detail Entered (Hear we want diffrence about nos ex 25 - 7 = 18)

pls help me for my this problem

thanks in advance

My file is enclosed

[Tinbendr]

Use labels instead of textboxes for static data.

[santosh226001]

Thank you very much for showing interest in my problem

but Sir little bit error show in calculation

in sheet total road 25 that show correct
but in sheet enter mention in 7 road but form show 6 road here is error

pls check this error

and sir one more thing is this form update automatically if i increase no of road in Sheets or u fix this upto 25 row onnly...


Thanks

[Tinbendr]

Sorry. I got the road numbers and row numbers confused. Try this.

Please Login or Register  to view this content.