AuUser
09-16-2020, 07:05 AM
I am a couple days new to VBA, I was wondering if it was possible for a UserForm to populate specific cells based on a combobox selection within the UserForm.
As well as the ComboBox selection coming from (ThisWorkbook.Names().RefersToRange) but filtering based on the column to the right.
I.e.
Column C is the Shelving Unit Number with the defined name.
Column D is if the Shelving Unit Number is being used by someone or not.
If this is a possibility, I would be grateful to hear how.
As well as the ComboBox selection coming from (ThisWorkbook.Names().RefersToRange) but filtering based on the column to the right.
I.e.
Column C is the Shelving Unit Number with the defined name.
Column D is if the Shelving Unit Number is being used by someone or not.
If this is a possibility, I would be grateful to hear how.