[ExcelVBA] Re: [need]onclick msgbox

 

now will you please help me with one last thing
i want to make a button on the sheet by clicking on it a sub may run
i will be grateful to you

--- In ExcelVBA@yahoogroups.com, Paul Schreiner <schreiner_paul@...> wrote:
>
> You could create a SelectionChange Event.
> If it is for this sheet only, then it can be in the sheet module.
> I the event macro, test to see if the selection is the cell you're monitoring.
>
> Like:
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>     If (Target.Address = "$A$1") Then MsgBox Target.Address & " is selected"
> End Sub
>
>  
> Paul
> -----------------------------------------
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -----------------------------------------
>
>
>
>
> ________________________________
> From: wasayraza90 <wasay.raza.qadri@...>
> To: ExcelVBA@yahoogroups.com
> Sent: Thu, March 1, 2012 5:18:57 PM
> Subject: [ExcelVBA] [need]onclick msgbox
>
>  
> i want to apply such a macro that when i click a cell a msgbox opens
> like
> onclick.ActiveSheet.Cells(1, 1).MsgBox Msg
> this type of something
> can any one help me how to do this.
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___