TextBox Properties

[fucell]

Hi to all..

I just want to ask if theres a way to enable and disabled 8 textbox in a shorter code (excek macro). below is my code

txt1.enable = true
txt2.enable = true
txt3.enable = true
txt4.enable = true
txt5.enable = true
txt6.enable = true

thanks in advance.

fucell

 

[fucell]

or should i say, is there a way to shorten this code ?

Range("b2").Value = frmquote.txtdate.Value
Range("b3").Value = frmquote.txtquote.Value
Range("b4").Value = frmquote.txtsalesman.Value
Range("b5").Value = frmquote.txtdterequired.Value
Range("b8").Value = frmquote.txtCompName.Value
Range("b9").Value = frmquote.txtadd1.Value
Range("b10").Value = frmquote.cmbo1.Value

frmquote.txtdate.enable = false
frmquote.txtquote.enable = false
frmquote.txtsalesman.enable = false
frmquote.txtdterequired.enable = false
frmquote.txtCompName.enable = false
frmquote.txtadd1.enable = false
frmquote.cmbo1.enable = false

thanks in advance.