Forum Discussion

Jecynta's avatar
Jecynta
Copper Contributor
Oct 03, 2019

Change List Selection VBA

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!!

Dropdown Lists
VBA

1 Reply

  • JCPHedin's avatar
    JCPHedin
    Copper Contributor
    Mar 13, 2020

    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

Resources