hello all
im not that strong in writing vba codes , only know stuff from reading around here as spactator.
i would like to get help as i need to creat a code in my userform that check if the opreator entering any value to text box other then 0 or blank . if he is trying to enter 0 or Blank it prevent from moving FW.
textboxs is copying its profit multipliers values to a certain sheet in the workbook that reflacts the pricing per s\e after i press command button, this generating forcasting tables later on.
so i must make sure that the end user wont be able to entere 0 or blank value for any textbox given
thats my code so far:
HTML
Private Sub CommandButton1_Click()
s1.Range("F2") = uf1.TextBox43.Value
s1.Range("F3") = uf1.TextBox44.Value
s1.Range("F4") = uf1.TextBox45.Value
s1.Range("F5") = uf1.TextBox46.Value
s1.Range("F6") = uf1.TextBox47.Value
s1.Range("F7") = uf1.TextBox48.Value
s1.Range("F8") = uf1.TextBox49.Value
s1.Range("F9") = uf1.TextBox50.Value
s1.Range("F10") = uf1.TextBox51.Value
s1.Range("F11") = uf1.TextBox52.Value
s1.Range("F12") = uf1.TextBox53.Value
s1.Range("F13") = uf1.TextBox54.Value
s1.Range("F14") = uf1.TextBox55.Value
s1.Range("F15") = uf1.TextBox56.Value
Unload Me
End Sub
Display More
thanks guys