Hi all,
I am having some problems on blocking some textboxes, depending the choice of made on the combobox (cboTM), i could do well for "Material" but for "Worklabor" and "equipments", only the opaque didnt worked
the other thing was, how i put the correct info on the texboxes :
if i choose "materials" from cboTM, and option 1 ("B7") from cboDM, textemp and textHours will become blocked and the dada from the sheet "material" will appear on the textboxes like that:
(sheet Material)
textmeasure ="C7"
textQuant="D7"
textprice="E7"
texttprice="F7"
same to Worklabor :
if i choose "worklabor" from cboTM, and option 1 ("B7") from cboDM, textQuant will become blocked and the dada from the sheet "worklabor" will appear on the textboxes like that:
(sheet Worklabor)
textmeasure ="C7"
textemp="D7"
textHours="E7"
textprice="F7"
texttprice="G7"
and the same for Equipents....etc..
file attacked.
I am having some problems on blocking some textboxes, depending the choice of made on the combobox (cboTM), i could do well for "Material" but for "Worklabor" and "equipments", only the opaque didnt worked
the other thing was, how i put the correct info on the texboxes :
if i choose "materials" from cboTM, and option 1 ("B7") from cboDM, textemp and textHours will become blocked and the dada from the sheet "material" will appear on the textboxes like that:
(sheet Material)
textmeasure ="C7"
textQuant="D7"
textprice="E7"
texttprice="F7"
same to Worklabor :
if i choose "worklabor" from cboTM, and option 1 ("B7") from cboDM, textQuant will become blocked and the dada from the sheet "worklabor" will appear on the textboxes like that:
(sheet Worklabor)
textmeasure ="C7"
textemp="D7"
textHours="E7"
textprice="F7"
texttprice="G7"
and the same for Equipents....etc..
file attacked.
Attachments
Last edited: