RE: $$Excel-Macros$$ Help needed in creating a Dashbord

Give some data...in which you want to work even dummy data. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of alisha malhotra Sent: Tuesday, October 15, 2013 11:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed in creating a Dash

Re: $$Excel-Macros$$ Custom buttons

The last step is what I have a question with. I want to use an image I designed, not ones that are in the window. Is there a way to use my own image on a button? On Tuesday, October 15, 2013 12:11:53 PM UTC-4, Faisal PK wrote: > Hi, > > Please check if it will help. > > Office Button=> Exc

$$Excel-Macros$$ Help needed in creating a Dashbord

Hi, I am working in HR department in a manufacturing company and want to create a dashboard. Please guide me in preparing the same like the things to be covered in the dashboard How can I link some list box or combo box to a chart in the dashboard without macro i.e. through formulas if it can b

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Hello, When i open the file and enter 2 addresses in the excel sheet, it does not give me a value in the Function(UDF) collumn? Even if i hit Alt+F11, it brings me into the VBA screen. Am I doing something wrong? Any help appreciated. On Saturday, February 25, 2012 6:01:12 AM UTC-7, ashi

Re: $$Excel-Macros$$ Custom buttons

Hi, Please check if it will help. Office Button=> Excel Options => Customize 1. Select 'Macros' from 'Choose commands from' to get your macros listed. 2. Select the macro you need to assing. 3. Click 'Add' button to get it added to quick access toolbar list. 3. Select the macro from quick access

$$Excel-Macros$$ Custom buttons

Hi, Is there a way to create a custom button (a button image that I designed) then assign a macro to it and put it in the quick access toolbar? Doug -- 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 @

$$Excel-Macros$$ Re:

Dear Sandeep, i did some testing, and here is working properly, the only error that appears, is when the macro finds some protected worksheet. Try using a new worksheet and paste this code below ... and then test to see if it works. Option Explicit #If VBA7 Then Private Type BROWSEINFO

$$Excel-Macros$$ Re: Display Vlookup dialog box with vba code

I got the following code to work: Application.SendKeys ("%mf") Application.SendKeys ("vlookup") Application.SendKeys ("{ENTER}") Application.SendKeys ("{ENTER}") On Thursday, October 10, 2013 7:59:29 AM UTC-4, dr wrote: > Hi, > > Does anyone know how to display the vlookup dialog box using

Re: $$Excel-Macros$$ Re:

Thank you Basole for your reply. But after the suggested changes when i am running the code it is showing me error code 400. any specific reason. On 15 October 2013 17:49, Basole wrote: > Hi Sandeep, try this: > > > Replaces the highlighted code for this: > > > Option Explicit > > #If VBA7 The

$$Excel-Macros$$ Re:

Hi Sandeep, try this: > Replaces the highlighted code for this: Option Explicit #If VBA7 Then Private Type BROWSEINFO hOwner As LongPtr pidlRoot As LongPtr pszDisplayName As String lpszTitle As String ulFlags As Long lpfn As LongPtr lP

$$Excel-Macros$$

Dear Excel Gurus, I have got this Macro from this forum for* adding worksheets from different work book kept in a folder,* but now when i am trying this code I am getting compiling error message" can not define a public user defined type with an object module. Please help. Thanks in advance. Op

Re: $$Excel-Macros$$ MS Excel 2003 to 2010

Hi Prashant, Please download Interactive menu to ribbon guide http://www.microsoft.com/en-us/download/confirmation.aspx?id=16642 . Enjoy Team XLS On Mon, Oct 14, 2013 at 3:21 PM, Prashant Pednekar wrote: > Dear friends > > We are migrating from MS Excel 2003 to Excel