Show/Hide a sepcific column based on a condition in a cell

[uakhan]

Hello everyone.
I would appreciate if some one can write the VBA for the following

If cell G5=TRUE then hide entire column I and show entire column H. If cell G5=FALSE then hide entire column H and show entire column I.
VBA should get triggered each time the value of cell G5 changes.

Thanks

[Kaper]

in the code of Sheet with G5 cell (right click on the tab with sheet name and choose show code) such a procedure:

Please Login or Register  to view this content.

would do the work

[uakhan]

Dear Kaper
Thanks for a quick response. However the code is partially working only and it hides column H whether the value of G5 changes to FALSE or to TRUE and doesn't do anything to column I. I will mention my requirement again below:
If G5=TRUE then Hide column I and unhide column H
If G5=FALSE then Hide column H and unhide column I