Hey VBA folks,
Can you help a newbie with this issue?
I have a UserForm that has a ComboBox with two columns.
I would like to have each Column in the ComboBox transferred to 2 seperate cells in a worksheet.
I have all other items working but this one.
I have sheet1 with 2 columns: "trap location" and "bait used". I have named this 2 column list "TrapList"
I have sheet2, RodentLog, to log the input with several columns. Column 3 is for "trap location" and column 6 is for "bait used".
I have tried unsuccessfully to make this work.
Any help would be greatly appreciated.
Thanks in advance
D-Dog
Bookmarks