Help my brain has disappeared and i can't figure out this stupid answer aaaaaaahhhhhh!!!!

Posted by David on August 02, 2000 9:43 PM

I have a combo box
when the value in it is change i want two other cells to change automatically. They are not based on what the combobox is changed from or to just the fact that is was changed. What is the command i am looking for
I am using
If Target.Address = "$b$1" Then
b1 being the cell the combo box is referencing but that does not work
help me please???

Posted by Ivan Moala on August 03, 0100 3:33 AM

Hi David
I've emailed you your workbook example.
Let me know if any light was shined on your problem
bur basically you have to use a worksheet calculate event to trigger what you need to
happen.

Ivan

Posted by David on August 03, 0100 8:33 PM

Still not working

I understand why mine is not working though.
I don't want a macro to run. At least not one that I am presently using.

If the value in B1 changes(which is linked to a combo box) then I want b2 (which is linked to another combo box) to be reset to 1 and B2 which is not linked to anything to be cleared. None of that in itself is linked to a macro.

Posted by david on August 03, 0100 10:36 PM

Thanks Ivan

Ivan helped me with this problem through email

Private Sub Worksheet_Calculate()
If Range("a1").Value &LT;&GT; temp Then
Range("b2") = "1"
Range("B6").ClearContents
End If
temp = Range("a1").Value
End Sub

Works great now
by changing cell a1 to =b1*1

That way when B1 changes it calculates a1 and if a1 id different then the old value of b1 (temp) then it set b2 to 1 and clears out the cell I wanted I understand why mine is not working though.