This is an Excel 2003 problem. I am trying to create two unrelated listboxes on the same worksheet (titled General) using data validation. I created the first listbox called Logtype with no problem. The list items are in cells A1:A5 of Sheet3. The second listbox is to contain the contents of cells Rectype which are C1:C6 on Sheet 3 (have also tried cells A1:A6 on Sheet4), but contains the Logtype list instead. I have tried making the second listbox a combobox but it still populates with the Logtype list as well. I don't know VBA and would like to stay away from it (and macros) if possible because of site security restrictions. The workbook I am using is attached.
Thanks.
Bookmarks