Search results

srinidhi, As Luke said it correctly you cannot do this using a UDF... However this can be done using Procedures Look at the file: https://docs.google.com/open?id=0BxRkrdCm95qbVzhqZUE0WFAwMVU Let us know if this is what you were after... For illustration I have only applied the...

Hello Raghava, You would need to place the below code in the excel file on a module and then add your code. Option Explicit Public cnn As Object Public rs As Object Public strSQL As String Sub OpenDB() Set cnn = CreateObject("ADODB.Connection") cnn.connectionstring =...

Is it possible for you to upload your file? ~VijaySharma

Hello Suresh, Please find the link below for the updated code.... You need to run this only once a day after you have finished the data entry part. I have assumed that the employee data sheets will be named after their employeeID...

Hello theSponsor, when you need to work on this again you would need to create a list of Unique Horse list in Sheet 1. Replace the old report data with the new one and simple run the macro again. If your list of choices for horses is going to remain static (12 columns)currently then we can...

Hello Suresh, Welcome to Chandoo.Org Forums. If the name of the source CSV file remains static, you could declare a CONST variable in the Macro to refer to the file. If the name changes and has a date component, you could still generate this inside your macro. HTH ~VijaySharma

Hello theSponsor, Welcome to Chandoo.Org If VBA and a bit of SQL is not an issue... have a look at the file https://docs.google.com/open?id=0BxRkrdCm95qbNksyVURnZE1iZkk 1. I created a separate sheet for all Unique Horses 2. Press ALT+F8 funtion key and then select the Macro called...

@Sudeep, Try this file... https://docs.google.com/open?id=0BxRkrdCm95qbZjhGMFNfV1QxVW8 HTH ~VijaySharma

@Ajinkya, File updated... https://docs.google.com/open?id=0BxRkrdCm95qbSFhUcDNfTE9WaVE I hope this is what you were looking for. ~VijaySharma

@Ajinkya, See if this helps... https://docs.google.com/open?id=0BxRkrdCm95qbdUxKbVJlWEo1Unc ~VijaySharma

Subroto, Could you please put some more light on your requirements, start and stop makes sense to me, Pause does not. This maybe because you have not specified the actual requirements. SirJB7, Again agree with what you have said, I will try to work on this once I get the above details...

Whilst what SirJB7 has said above is true, there is a wrok around available. Try the code below to see the message box every 5 seconds, you may adjust the timer as per your needs. Sub RunThis() 'to enable this timer everytime the workbook is opened 'you would need to call this...

Another solution... https://docs.google.com/open?id=0BxRkrdCm95qbWEU5cmZ3M0tTZkt0ekNNcGxBT1dKQQ ~VijaySharma

jkveerya, The code I have sent is going to do exactly the same. Can you upload you file on Google Docs OR SkyDrive so that I can download. ~VijaySharma

In Data Validation, Go to the Error Tab, and remove the Check mark from "Show Alert when Invalid Data Is Entered". Select all you cells where you want the default text to be displayed.... enter the default text. Now enable the Drop Down as well... What you will see is the default text...

@jkveerya, Welcome to Chandoo.Org Forums. Start the VBEditor Double Click on ThisWorkBook inside the Project Explorer Now Paste the Below Code Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Sh.Name = "YourSheetName" And Target.Address = "$A$1"...

Here you go.... Sub ExtractNames() Dim cntr As Long Sheets("Sheet2").Select Cells.ClearContents Range("A1").Select cntr = 1 ActiveCell.Offset(0, 0) = "Name as defined" ActiveCell.Offset(0, 1) = "Contnets of the defined name" Do While cntr <=...

@mail3denraj, 1. These are not due to any addins on your system. 2. There are options that are Context relative, like the Pivot Tab become available when you are working with a Pivot. 3. How to make them hidden is a good point to ponder on, something that I have not done lately... there...

@Sonia, This is not possible unless you have the mechanism (using a temporary sheet) to store the values of all related variables that may be used when calling the Sub the second time. You can delcare a Boolean variable to check if the end user is calling the Sub first time or second...

@Sachin, Is it possible for you to upload you file for us to look at. Put it on Google Docs or SkyDrive... ~VijaySharma

@Santosh, While this may take some to come... you may send me your queries at sharma.vijay1@gmail.com. or Post your queries here on the Forum itself... I will help out as much as possible. ~VijaySharma

Prasad, I don't think the second part will be possible without VBA... as an event is happening when we click on the Hyperlink and we need an event handler to capture the same and then process. What you have already done with the Worksheet event is the only way out as far as I understand...

Hi all, Interesting thread... here are my 2 cents based on my understanding... Objectives / Scenario 1. A userform is being used to capture the data from the users and the data is saved on an excel sheet within the container workbook. 2. Next the user hits the send mail button and the Raw...

Do you mean... when you click on cell A1... then lock the scroll area to A1:F10... and if any other cell is clicked then unlock the scroll area? ~VijaySharma

@Kalpesh, 1. Press Alt+F11 to get the VB Editor on the Screen. 2. Go to View Menu and Click on Project Explorer. 3. On the Left Hand side.... Double Click on Sheet1 4. Paste the below code... Now everytime you click on Cell A5... you will get the message box... (change this to run your...