Hi all. New to VBA. I have a userform with comboboxes. The first combobox has a rowsource assigned through properties, on selection it runs an advanced filter. I have named a range from the extraction "WIPHeader" to polulate a second combobox which on selection from this populates some textboxes successfully, however, one of these textboxes calls for data outside of the named range. i.e. the named range is columns G to K, however the data for this textbox is in column F of the extraction from the advance filter. Is it possible to offset the named range back one column? The below column(-1) doesn't work.
Second combobox:Please Login or Register to view this content.
Populates textboxes - WIP7 refers to supplier details which is outside the named range "WIPHeader"Please Login or Register to view this content.
I'm unable to post the workbook at this time as I'm too far into the project with sensitive data.Please Login or Register to view this content.
Any help would be appreciated.
Bookmarks