MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

update cell based on hyperlink selected

  Asked By: Ayman    Date: Dec 29    Category: MS Office    Views: 2471

i have 2 sheets in excel-2007, sheet1 contains columns A & B, colomn A (A1:A100)has numbers from 1 to 100 and colomn B (B1:B100) has texts to be used as hyperlinkes,sheet2 has cell B1, i want VBA to update the value of cell B1 in sheet2 when clicking on hyperlink on sheet1 (example B5) and returns the crosponding value on sheet1 (example A5).



1 Answer Found

Answer #1    Answered By: Ayman Gabr     Answered On: Jan 07

hello,,, please i need your help to solve this problem, can any one help me.

Didn't find what you were looking for? Find more on update cell based on hyperlink selected Or get search suggestion and latest updates.