Hi I have been watching this thread for a long time. While doing a little research on Google. I came up with two links that I thought can help you guys.
http://www.eggheadcafe.com/conversation.aspx?messageid=31624005&threadid=31623988 http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23543107.html Please look at the links above. Please let me know if it helps. Regards, Andy On Fri, May 8, 2009 at 11:14 AM, Akhilesh Karna <akhiles...@gmail.com>wrote: > The following code may be of help: > > open excel > open visual basic editor > double click sheet1 (or any other sheet) under microsoft excel objects > Add the following code > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > If Intersect(Range("C:C"), Target) Is Nothing Then > 'do nothing > Else > MsgBox "it is changed" > End If > End Sub > > You can do many thing by just clicking a cell in column C (in this > example). > > > Akhilesh Kumar Karna > > > On Fri, May 8, 2009 at 4:58 AM, Doug <dsrmccl...@gmail.com> wrote: > >> >> I've got an Excel spreadsheet that I'm going to use a wedge program >> with to capture data from an instrument and parse it into the sheet. I >> would like to make it happen without having to use a mouse to click a >> button. A hot key combo or a form would work but it would be really >> sweet if I could just press Enter from the correct cell. >> >> Is it possible to run a macro by simply hitting enter on a cell >> without even entering any data in the cell? The active cell will >> always be in column 4. >> >> None of the answers I found online so far work for me. >> >> Thanks. >> Doug >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
