Re: [ExcelVBA] Re: [need]onclick msgbox

 

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@gmail.com>
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 (6)

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

.

__,_._,___