Search results

Thanks for the bird information and guidance. I will look into this. many Thanks again. This is the best web site to learn excel.... Hui, JB, Colin Legg, Faseeh and NARAYANK991 with out your expertise I would have never been able to progress further. thank you for your tiem and energy in...

Genius... Thank you so much. it has save so much time for me.... For Each ch In ws.ChartObjects ch.Activate ch.Chart.ChartTitle.Select With Selection.Font.Name = Fnt Selection.Font.Size = FntSz Selection.Font.Color = RGB(FntR, FntG, FntB) Application.GoTo Range("a1") End With

Many Thanks.

Pivot table 1 is the same as pivot tabel 2 and 3 yet 4 does not need to change. I would like this that either 1,2 or 3 can be changed. Also 5 and 6 are the same with a different field and I would ike them to be linked together. Thanks.

'Statistics Month'!$A$2:$A$79 My Drop down box looks up mm-yyy on another sheet. I would like to set the drop down boxes to this month. how can I do this. At present I can only set them to a .listindex e.g. 'Set listindex to be month of today. Sheets("Dashboard (Overview)").Select...

Hi, When I run this program the chart forulas go missing any ideas on how I can keep the formula. excample of a formula is : ='Dashboard (Individual)'!$A$60 I have over 20 of these on various sheets. listed bleow is my program. Sub ChartTitlesLight() Dim ws As Worksheet Dim ch As...

Hi I have 6 pivot tables and they are all set to one date. How Can I with VBA have that if I change one then they all chnage to the same date. The date is shown either on the first row or as a top item. They are all on the same work sheet Thanks.

OR... ANy way to explain then I run this the chart titles loose the formula to be equal to a cell ref number. Dim Fnt As String Dim FntSz As Double Dim FntR As Integer Dim FntG As Integer Dim FntB As Integer Fnt = "Rockwell (Body)" 'Set Font type FntSz = 14 'Set Font Size 'Black...

Can any one finish this program please. Sub Chart2() 'If pivot table field is changed then do this Sheets("Dashboard (Individual)").Select ActiveSheet.ChartObjects("1").Activate ActiveChart.ChartTitle.Select Selection.Characters.Text =...

Thanks Alot kaushik and narayan for your time. I will wait until I go home and try again by just clickng on the link. where I work is a secure zone so I only have a few hours before I go home. must be such a simple answer to this with two lines as I have tried various methods the last was over...

Thanks for the assistance they are all blocked here at work. I will look when I go home. I am sure t is a simple answer. Just having one of those days. I can remove multi items from a pivot via a vba script yet can not select. visiable = true does not work for me. Many thanks for you time to...

Hi, I am at work and this location is blocked ? Can any one upload the code for me here or copy and paste it please. Thanks.

I will try again. it was asking for me to set up an account. I will try again just clicking on the link and then clicking on the file name. thank you.

Hi, SOrry about this yet does any one know the answer to this as I can not gain an account at speedy. Any program would give me an understanding. thanks....

Hi, Thanks for the reply. I am trying to create a basic account and can not find this screen. do you have anotehr means of uploading the data. e.g. via this web site.

Hi, I would like to know if a person has a program that can select only a select items in a pivot table. I would like to show select memebers of a team in a pivot table when i run a macro. I have 3 teams to show. Below is my first and second attempt ? Each team has for example 5 members...

Thanks for all your help guys. Hui, Colin and JB to name the top 3. I have stopped working on the Dashboard. I will be working on my own projects from now on. Thanks all for you assistance. It was a good learning experience.

I have not been able to solve this. I will just set these manually each month. Unless any one know how to do this. did try .value and that also is not the solution as it does not change the chart values. thanks for the advise and also the programming which I will find a use for in other...

Still trying to find the answer to this. please see notes above. .listindex = 24 .<What is this> = Dec-12 Thanks.

Hi Colin The drop down boxes all have links to this spreasheet wherer the data is housed. 'Statistics Month'!$A$2:$A$49 A2-A49 has months and years.... some have Year Total eg. Year 2012 Each drop down then has the data set with the index being D5 =INDEX('Statistics...

Thansk Colin it is coming closer to my solution. I have some drop down boxes that have mmm-yy and some have dd-mm-yy on the same sheets. Also I would like to reference on want is the value of the .listindex e,g, .listindex 24 = Dec-12 Is this possiable. Then each drop down can be set to...

Thanks for the advise. it is a little more complex than this. The drop down looks up data on another worksheet and displays the data in charts. the cahrts are controled by the dropdown list. e.g. data for Dec-12 is shown in the cells and also the chart updates to the same month...

Hi, Can any one get this working for me please. I can set Listitems yet woud like to set the dropdown to now not a value so the program does not need updating each month. Thanks. Sub test1 () Sheets("Sheet1").Select Sheets("Sheet1").DropDowns("Drop Down 1927").ListItem = 26...

Still searching for the answer if any one know how to do this. will keep you posted if I can work out the answer see previous questions as I have provided some answer to other questios around macros on listboxes and pivot tables. hope it helps people.

My Soluton for each of the listboxes is as follows : Sheets("sheet12).Select ActiveSheet.ChartObjects("8").Activate ActiveChart.ChartTitle.Select 'Selection.Characters.Text = Range("A1").Value Selection.Characters.Text = Application.WorksheetFunction.Text(Range("c6").Value, "dd/mm/yyyy")...