Hi
Everyone I have been stuck in a problem could you please help.
Actually the problem is:
I have two columns one with names of cities and the other one is their pictures.
using this Formula:
=INDIRECT(ADDRESS(2-1+MATCH(Sheet4!$G$2, Sheet4!$A$2:$A$5, 0), 2))
I am able to filter the record, like if I enter Pakistan the next cell shows its picture.
Now, What I am trying to do is, I want to enter the value throgu a user form text box, So if I enter Pakistan then it will chnage its picture to Pakistan.
Where I am right now?
I have designed the form, also I am able to send the value from text box to cell (Names) where the fomrula is implemented, but doing so did not chane the picuture, whereas I enter a value manually in that cell and press enter, it works absolutely fine.
Why I want to do this because, I want the record to be dynamic I mean whatever the user will enter in the text box the picutre should be changes in to the next cell.
Looking forward for you help.
Thanks
Shozib
Bookmarks