$$Excel-Macros$$ Re: Excel Macros Book?

Hi, here is another one: http://excel-macros.googlegroups.com/attach/4d97bd1a51c32c86/O%27Reilly+-+VB+%26+VBA+In+A+Nutshell.zip?part=4 On Sep 15, 7:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > Thanks i

$$Excel-Macros$$ Re: New comer to the excel macros

Hi, in this lik there is a good manual: http://excel-macros.googlegroups.com/attach/4d97bd1a51c32c86/O%27Reilly+-+VB+%26+VBA+In+A+Nutshell.zip?part=4 On Sep 18, 10:31 pm, "v sheeba" <[EMAIL PROTECTED]> wrote: > Hi all, >  I would like to learn excel macros. Its any one teach me the simplest way >

$$Excel-Macros$$ Re: Make a cell a control that launches macro when clicked

Hi Tony, try this code: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'Adjust to your range If Intersect(Target, Range("A2:A25")) Is Nothing Then Exit Sub MsgBox "macro" 'your code End Sub Tony Bender wrote: > Is there a way to set a cell so when the user clicks