I've attached an Excel file that currently only uses 1 sheet (Sheet1). If you look all the way to the right in Sheet1, you'll see data in columns XFA through XFD. The two comboboxes and single textbox on Sheet1 reference that data.
All I would like to do is have the code under the textbox in Sheet1 reference columns A through D of Sheet1A rather than XFA through XFD of Sheet1. I tried modifying it myself and I can't get it to work.
In other words, what I'm looking to do is replace Sheet1's use of columns XFA through XFD with columns A through D of Sheet1A. What I did so far was to create a new sheet (Sheet1A. My original file only had one sheet) and copied the data from XFA through XFD of Sheet1 to A through D of Sheet1A. I'm now trying to modify Sheet1's textbox code (on row 3 starting in column C) to reference Sheet1A instead of Sheet1. The version of the file I attached does not have the comboboxes updated with the correct LinkedCells and ListFillRanges although I do have those working on my end with a different version. For example, the LinkedCell of the leftmost combobox is: Sheet1A!B1