VALUES CORRESPONDING FROM SHEET1 / SHEET2
 

I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much

VALUES CORRESPONDING FROM SHEET1 / SHEET2
 

Hi
why is a formula no alternative for you (e.g. VLOOKUP)?
Otherwise you have to use an event procedure (the
worksheet_change event)

-----Original Message-----
I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much


.

VALUES CORRESPONDING FROM SHEET1 / SHEET2
 

With Vlookup it has to be a sorted alphabaticly list.
plus the fact that they want it in VB, and no formulas
waht so ever on teh sheet
-----Original Message-----
Hi
why is a formula no alternative for you (e.g. VLOOKUP)?
Otherwise you have to use an event procedure (the
worksheet_change event)

-----Original Message-----
I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much


.

.

VALUES CORRESPONDING FROM SHEET1 / SHEET2
 

Vlookup doesn't require that the information be sorted if you are looking
for an exact match.

--
Regards,
Tom Ogilvy

wrote in message
...
With Vlookup it has to be a sorted alphabaticly list.
plus the fact that they want it in VB, and no formulas
waht so ever on teh sheet
-----Original Message-----
Hi
why is a formula no alternative for you (e.g. VLOOKUP)?
Otherwise you have to use an event procedure (the
worksheet_change event)

-----Original Message-----
I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much


.

.