Dashboard -Help on this VBA code

[JawaharPrem]

Hi All,

i have created on dashboard with button and vba code it work sucessfully, but i have to make some change in that. in my dashboard i have 3 types of count ("Tele, Field and tele to field")

Now i have given a 3 option button "overall, Field and Tele".
Ex 1 - If i select the overall option button i need get full dashboard
Ex 2 - If is select the field option button i need to get only Field and tele to field data.
Ex 3 - If is select the tele option button i need to get only tele releate data.

It is possible pleas help on same.
Enclosed my sample dashboard for your reference.

Thanks
Jawahar Prem

 

[NARAYANK991]

Hi ,

Please explain clearly , with examples.

What is supposed to happen when each of the 3 option buttons is clicked ?

Are columns to be hidden ? If so , which columns should be hidden for each option button ?

Narayan

 

[JawaharPrem]

Hi Narayan,

I have enclosed sample file what should happen if select option button "overall, field and tele".

Thanks.

 

[NARAYANK991]

Hi ,

Thanks. Please check back later.

Narayan

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[JawaharPrem]

Hi,

Thanks, Just i need to past the code for summary file.

 

[NARAYANK991]

Hi ,

Sorry about that ; I deleted the module by mistake.

Narayan

 

[JawaharPrem]

Hi,

if i paste the module not working, Please help on same

 

[JawaharPrem]

hi,

If i paste the module option button command are not working getting erron "object required", how to correct the same.

 

[NARAYANK991]

Hi ,

A named range called Data needed to be defined. See your file now.

Narayan

 

[JawaharPrem]

Hi,

in name manager, first time working fine, "#ref" goes next time or if select any other button.

if i select tele file data too listed the same happens in field too.

i need to define for every dashboard in data sheet.

Thanks
Jawahar Prem

 

[NARAYANK991]

Hi ,

Can you upload your complete workbook ?

I cannot imagine spending so much time on such a small task.

Narayan

 

[JawaharPrem]

Hi,

Sorry about that, what i uploaded is complete workbook, it is working only for overall and vrp button not for others.

 

[NARAYANK991]

Hi ,

I have no idea about the code for the buttons , since I have not written it.

I have added the code for the 3 Option Buttons , that is all.

Narayan

 

[JawaharPrem]

Hi,

thanks, so i need to add other buttons in that code, thank your very much. i complete and share for your reference.

Thanks.
Jawahar Prem