Hello,
I used the VBA code above to clear the contents of a field if the parent field is cleared.Please Login or Register to view this content.
I have realized that it is too confusing to give the users a choice for column I, so I'm trying to auto-populate it based on their selection in column H.
I'm using the formula =IF(ISBLANK(H72),"",VLOOKUP(H72,OrderType,2,FALSE)) in column I and it works perfectly until I delete the selection in column G or H!
Is there a way to have the clearcontents NOT clear formulas?
Please let me know if you need me to post a sample.
Thank you,
Kim
Moderator's Edit: Use code tags when posting code. To do so, select the code and click on the # icon at the top of your post window.
Bookmarks