I have two radio buttons on an excel form;
ButHorse1
ButHorse2
and a text box called txt_HorseName
I have a spreadsheet called LookupLists with two named ranges Horse1 in ("R2") and Horse 2 in ("S2") I want the user to click a radio button on the form (either ButHorse1 or ButHorse2) and it show the appropriate text from the LookupLists (so for ButHorse1 = text in R2 - named range Horse1 and for ButHorse2 = text in S2- named range Horse2.
It doesn't seem to work and it overwrites the name of the field in the LookupLists
any pointers in the right direction is greatly appreciated. Thank you
Bookmarks