ComboBox for selection sheet and run macro

[ayazgreat]

Sir

I have got 8 sheets in a workbook having the following names first one is Main,and others are Aw,Nzm,Mhk,Gul,Qta,and Hdr.

I want a ComboBox in every sheet displaying names of all sheets in combobox and when i select a name of sheet from combobox it goes to that sheet after hidding sheet where selection was made and running macro codes which i have developed for sheet. I want only one sheet display on the screen when one selection is made other one is invisible.

Thanks in advance.

Ayazgreat

 

[ayazgreat]

Sir

I mean to say that when I select a sheet name from combobox then selected sheet is visible and other one is invisible I have developed some my macro for each sheet to display " Reconcilation Result" and i want these codes to be run with your given selection codes.

Thanks

 

[Tom Urtis]

Then use the Run statement to run whatever macro you want to run. Immediately above the last codeline
Application.ScreenUpdating = True
in the ComboBox1_Change event I just posted, insert this line, modify for whatever macro name it really is you want to run:

Run "Reconcilation Result"

 

[ayazgreat]

I have nothing words to say but "A bundle of thanks for you"
Looking so smart in your Picture.

Thanks
Ayazgreat