Private Sub CommandButton2_Click()
Application.ScreeUpdating = False
Application.Goto Reference:=Range("A84"), _
Scroll:=True
[W94].Value = [G86*B86] + blah, blah, blah
[cbx1] = Empty
[databox1] = Empty
Range("B86").Select
Application.Screen.Updating = True
End Sub
I know in the above code i said [databox1] =
Empty, but what i am now trying to "fire off"
is [databox1] = [cbx1]?
databox1 is a textbox & cbx1 is a listbox
Any ideas?
James
Application.ScreeUpdating = False
Application.Goto Reference:=Range("A84"), _
Scroll:=True
[W94].Value = [G86*B86] + blah, blah, blah
[cbx1] = Empty
[databox1] = Empty
Range("B86").Select
Application.Screen.Updating = True
End Sub
I know in the above code i said [databox1] =
Empty, but what i am now trying to "fire off"
is [databox1] = [cbx1]?
databox1 is a textbox & cbx1 is a listbox
Any ideas?
James