Hi , I am newbie and I tried to get myself own construct of VBA with combination of a few VBAs ( small program) .
I am seeking help here and hope someone would be able to helo me out.
1. When this workbook opens, [O2] will consist of last save price.
2. [O2] last saved price will automatically compared with [D2] <Price withdrawed externally,other sheet>
3. [A1 ] <Status> will show accordingly with the comparison of [O2] & [D2],
for eg, if [O2] > [D2] . [A2] will show PRICE UP,and if [O2]<[D2], price down, else unchanged
Now, I can update above by keyin data into [C2] which is going to update [O2].
So, say if I enter [98] in [C2] , [O2] will change accordingly to 98 and [A2] <Status> will change to Price UP since market price is 100 which
is higher than the price in my store [98].
* I can actually manage to achieve above goal by entering some VBA codes into the [Button 3] and once the button is click,
cells data will update and make its respective responds accordingly. But this is not really what I looking for as I try
to have something where those data will automatically updated when its respective active cell has any data being entered.
*** Please help me out , I am so sorry to post this as I in fact tried and crack my head to do it own my own
with those VBAs code that I got from previous thread ( others helped in those VBA). But still I failed in doing so
as I dont really master in VBA.
I am seeking help here and hope someone would be able to helo me out.
1. When this workbook opens, [O2] will consist of last save price.
2. [O2] last saved price will automatically compared with [D2] <Price withdrawed externally,other sheet>
3. [A1 ] <Status> will show accordingly with the comparison of [O2] & [D2],
for eg, if [O2] > [D2] . [A2] will show PRICE UP,and if [O2]<[D2], price down, else unchanged
Now, I can update above by keyin data into [C2] which is going to update [O2].
So, say if I enter [98] in [C2] , [O2] will change accordingly to 98 and [A2] <Status> will change to Price UP since market price is 100 which
is higher than the price in my store [98].
* I can actually manage to achieve above goal by entering some VBA codes into the [Button 3] and once the button is click,
cells data will update and make its respective responds accordingly. But this is not really what I looking for as I try
to have something where those data will automatically updated when its respective active cell has any data being entered.
*** Please help me out , I am so sorry to post this as I in fact tried and crack my head to do it own my own
with those VBAs code that I got from previous thread ( others helped in those VBA). But still I failed in doing so
as I dont really master in VBA.