Excel VBA: DropDown Select Macro

[Nitya0808]

Hi All,

I have an excel, where a drop down is created using data validation icon in Excel. there are 8 entries.

There are 8 other hidden sheets in the excel whose name match that of the entries in the drop down list.

I need a piece of code, where when the selection is made in the drop down list: Cell C5, then the data from the particular sheet is displayed as a pop up.

Ex: I have 5 sheets named A,B,C,D,E.

When B is selected from the drop down list in the master sheet, then the contents of Sheet B (A1 to D24), is displayed as a pop up.

Thanks
Nitya

 

[gallen]

Re: Excel VBA: DropDown Selct Macro Help

Well yes it's possible but the code needed to copy the cells then display them in a pop up form isn't straight forward. May be a good side project for you to learn the VBA for it. I googled how to do it and found a few suggestions but wasn't as straight forward as I expected

 

[Nitya0808]

Re: Excel VBA: DropDown Selct Macro Help

Well yes it's possible but the code needed to copy the cells then display them in a pop up form isn't straight forward. May be a good side project for you to learn the VBA for it. I googled how to do it and found a few suggestions but wasn't as straight forward as I expected

Oh Okie. Thanks a Ton, i think in that case i will live with the current one.

Thank you