Hi, I found another post with interesting information : http://www.mrexcel.com/forum/showthread.php?t=181654
at.te 2009/5/10 Aindril De <aind...@gmail.com> > 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 >>> >>> >>> >> >> >> > > > > -- Fabio L Lemos email: flnle...@gmail.com --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
