I would like to create a VBA that takes the text that the user selects in a drop down list in cell B11 (there are only two options in the drop down list in this example) and then, based on that selection, changes cell D11 - either pulls a value from another tab and shades the cell gray, or sets the value to $0 and shades the cell white. The two text options in B11 are "Manual Entry" (this selection would set D11 to $0) and "Pull From Rehab Details" (this selection would pull a value from a cell in another tab). Can anybody help me?