Change List Selection VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-891224%22%20slang%3D%22en-US%22%3EChange%20List%20Selection%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891224%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Folks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20list%20of%20items%20is%20stored%20on%20one%20worksheet%20in%20a%20workbook.%20By%20selecting%20an%20option%20from%20a%20dropdown%20menu%2C%20the%20item%20may%20be%20copied%20to%20another%20sheet%20in%20the%20workbook.%20I%20need%20to%20be%20able%20to%20automatically%20change%20the%20selection%20in%20the%20dropdown%20on%20the%20initial%20worksheet.%20Can%20anyone%20help%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-891224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDropdown%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVba%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1226893%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20List%20Selection%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1226893%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419108%22%20target%3D%22_blank%22%3E%40Jecynta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20if%20i%20understand%20what%20you%20mean%20is%20correct.%20but%20try%20this%2C%20if%20it%20is%20because%20you%20want%20to%20change%20the%20content%20in%20the%20list%2C%20based%20on%20multiple%20Choice.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DF264FpBDX28%26amp%3Bt%3D79s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DF264FpBDX28%26amp%3Bt%3D79s%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eother%20wise%2C%20try%20a%203D%20formula%20if%20it%20based%20on%20the%20same%20cells%20spread%20out%20on%20multiple%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%26nbsp%3B%3C%2FP%3E%3CP%3EJulio%20C%C3%A9sar%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Folks!

 

A list of items is stored on one worksheet in a workbook. By selecting an option from a dropdown menu, the item may be copied to another sheet in the workbook. I need to be able to automatically change the selection in the dropdown on the initial worksheet. Can anyone help with this?

 

Thanks!!

1 Reply
Highlighted

Hey @Jecynta 

 

I'm not sure if i understand what you mean is correct. but try this, if it is because you want to change the content in the list, based on multiple Choice. 

https://www.youtube.com/watch?v=F264FpBDX28&t=79s

 

other wise, try a 3D formula if it based on the same cells spread out on multiple sheets.

 

Best Regards 

Julio César

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn all you need to know about INDEX & MATCH to get a quick...