$$Excel-Macros$$ powerpoint interactive dashboard (scrollbar) code for anyone (my gift)

2015-06-16 Thread Pascal Baro
enjoy Option Explicit Private Sub ScrollBar2_Change() Dim myChart As Chart Dim gChartData As ChartData Dim gWorkBook As Excel.Workbook Dim gWorkSheet As Excel.Worksheet Set myChart = ActivePresentation.Slides(4).Shapes(1).Chart Set gChartData = myChart.ChartData 'gChartData.Activate 'needs to

$$Excel-Macros$$ Re: Is it possible to hide the name manager menu?

2013-07-08 Thread pascal baro
Using Visual Studio it should be Now, is it possible to achieve this using Visual Studio Express? Pascal Baro http://multiskillz.elementfx.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Re: EXTRACTING DATA BASE ON MATCHING VALUE

2012-04-22 Thread Pascal Baro
Hi Sirag, to clear row 8 to row 100, I advise you to create another button so that you don't mix the cleaning part and the main process. Open vba ide, in the same module where you have the previous code, write or create a sub, like sub clearData and between sub and end sub enter Set wsB =

$$Excel-Macros$$ Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread Pascal Baro
, Pascal On Sun, Mar 4, 2012 at 12:58 PM, Pascal Baro bpascal...@gmail.com wrote: Ok i see i mail the group to delete my file (i copy you), you should also mail your request to the group so it's a coherent request for the same file On Sun, Mar 4, 2012 at 12:48 PM, Stewart Smith stewartrsm

$$Excel-Macros$$ not to be published

2012-02-22 Thread Pascal Baro
, Pascal Baro -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question