View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Sheet name change needed

Hi, I am new to programming but I would like to rename sheets based on drop
down lists. For example: on sheet1 I have a drop down that contains 2
choices, 1A or 2A that you can select...based on which one you choose, I
would like the name of sheet2 to be updated to match your selection from
sheet1. So, if I pick 1A from the dropdown on sheet1, sheet2 will be renamed
1A. Is this feasible? Thanks for any help,