[ExcelVBA] Re: [need]onclick msgbox

 

thanks man this really worked out.

in the previous msg you showed me how to create a selection change event in that macro, you had declared target as range. but i want to put it in a loop. what will be the code for that????

--- In ExcelVBA@yahoogroups.com, Paul Schreiner <schreiner_paul@...> wrote:
>
> What version of Excel are you using?
> They all do the same thing, but different versions have a different way of
> getting there.
>
> If you're using 2007 or 2010:
> go to the Developer tab.
> Click the toolbar Insert button.
> here you can insert either a Form button or an ActiveX button.
> I like the ActiveX buttons myself.
> with them, you can right-click the button and change the Name of the button, the
> text displayed, and other properties
> (like whether it prints if you print the sheet)
> also, you can then right-click on the button and select View Code.
> this will open the VBA editor and create a button click event.
> From here you simply enter the name of the macro you wish to run.
>
> if you use a form button, then you assign the macro to the button.
>  
> 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: Fri, March 2, 2012 1:19:56 PM
> Subject: [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]
> >
>
>
>
>
> [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 (7)

Recent Activity:

• New Members 10

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

.

__,_._,___