Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a action for a defined object
hello
first of all my apologizes for allways posting questions instead o solutions, but I m still too beginner in programming. I create a macro that format a range . Is it possible to "give" th range the power to call it. Letīs say it is possible what i want to d is have the abillity to call it just like: range("myrange").mymacro I know it sounds silly but.. thank you in advance Adri -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a action for a defined object
No you can't do that, but you can pass the range to the macro, like
Call myMacro(Range("A1:A10") .... Sub myMacro(Rng As Range) Msgbox rng.Address End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Adrix " wrote in message ... hello first of all my apologizes for allways posting questions instead of solutions, but I m still too beginner in programming. I create a macro that format a range . Is it possible to "give" the range the power to call it. Letīs say it is possible what i want to do is have the abillity to call it just like: range("myrange").mymacro I know it sounds silly but.. thank you in advance Adrix --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a action for a defined object
thank you any way.
ps- And it is possible to define a new obejct capable to do a ne action? thank -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a action for a defined object
Do you mean such as adding a button to a sheet?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Adrix " wrote in message ... thank you any way. ps- And it is possible to define a new obejct capable to do a new action? thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application Defined or object defined error | Excel Programming | |||
Application-defined or object-defined error | Excel Programming | |||
1004 App - defined or object-defined error | Excel Programming | |||
Application-defined or object-defined error | Excel Programming |