hi.
i want ti know that is it possible to bring a text box with a formula.
there is a file attach that explain everything in it.
hi.
i want ti know that is it possible to bring a text box with a formula.
there is a file attach that explain everything in it.
No, but you could try this in B3:
=INDEX('2'!$B$3:$O$3,,MATCH('1'!C2,'2'!$B$1:$O$1))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello musicbox,
See if this is what you want. I needed to write some VBA code to do what you wanted.
Holiday event display object.xlsm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
hi, and thanks.
its work but how did u define the text box that
use for show or hide in vba?
I didn't define it, I copied it from your other sheet and pasted it on sheet 1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks