Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
circular reference in VB
Hi, I have a stock program, I want the posibility that if someone put in some
cell (lets say a1) a code, in the other cell appears the description (lets say b2). until this point everithing is easy (just adding a lookup function in cell b2) the problem is that I want that if the user type the description in the description cell (b1) the code appears (in cell a1), I thougt to use the following code : Private Sub Worksheet_Change(ByVal Target As Range) if target.address="$A$1" then cells(1,2)= "vlookup(.................................... end if if target.address="$b$1" then cells(1,2)= "vlookup(.................................... end if End Sub it works just fine, the problem is that THE CODE IS EXECUTED FOR EVER, it dosn't stop, I know exactly why it dosn't stop (because it create a circualr reference and it's executed when a dependient cell of it self changes), but I have no idea how to do what I want, any suggestions?????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
circular reference | Excel Worksheet Functions | |||
Circular reference | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
Circular reference help! | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Programming |