Hi All,
In my userform a user is able to enter "Yes" or "No" into textbox1. I want the value displayed in textbox2 to be determined by the user's entry in textbox1.
E.g.
User specifies "Yes"
Control Source for textbox2 is Cell A1
If user specifies "No"
Control Source for textbox2 is A2
I am trying to use IIf ( expr , truepart , falsepart ), but haven't had luck.
Any help would be great.
Edit:
As a side note, I'm only using a textbox for the "Yes" or "No" part because I wasn't sure how to use a listbox.
Bookmarks