how do i do something like this
I am completely new at this and would like to know how i can input say A1= number of boxes, and A2= number of pieces, and A3= sq. ft.. So 1 box would have 5.5 pieces equaling 11.72 sq. ft. Yeah no problem right? How can I make it to when i change the number in any cell, such as sq. ft. goes down, and it will reflect in pieces and boxes. I guess the sq. ft. per box and pieces are all true being that 1 box= 5.5pcs or 11.72 sq.ft. but i cant find anything to show me how to write the formula that keeps each beginning number true. At least that I can understand. Any help would be appreciated
how do i do something like this
Hi,
i have vba solution for this issue.
i have created toolboxes and simple vba coding.
i hope this will helpful for you.
if you have any queries and doubts let me know
email id: bsudhagar95@gmail.com
below i have mention vba coding for your reference.
Private Sub TextBox1_Change()
If TextBox1.Value = "" Then
TextBox4.Value = ""
TextBox5.Value = ""
ElseIf TextBox1.Value > 0 Then
TextBox4.Value = TextBox1.Value * 5.5
TextBox5.Value = TextBox1.Value * 11.72
End If
End Sub
Private Sub TextBox4_Change()
If TextBox4.Value = "" Then
TextBox1.Value = ""
TextBox5.Value = ""
ElseIf TextBox1.Value > 0 Then
TextBox1.Value = TextBox4.Value / 5.5
TextBox5.Value = TextBox1.Value * 11.72
End If
End Sub
Private Sub TextBox5_Change()
If TextBox5.Value = "" Then
TextBox1.Value = ""
TextBox4.Value = ""
ElseIf TextBox5.Value > 0 Then
TextBox1.Value = TextBox5.Value / 11.72
TextBox4.Value = TextBox1.Value * 5.5
End If
End Sub