Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to
extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
if -- Don Guillett SalesAid Software "Darren" wrote in message ... In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
damn big fingers
In simplest form, if you had a series of macros named MyNum1, MyNum2, -12 then Application.Run ("MyNum" & Month(Range("a2"))) -- Don Guillett SalesAid Software "Darren" wrote in message ... In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
Dim s as String
s = Format(Activesheet.Range("A1").Value,"mmmm") Application.Run "'" & Thisworkbook.name & "'!" & s -- Regards, Tom Ogilvy "Darren" wrote in message ... In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
The suggestions work fine
thanks for the help -- Darren "Darren" wrote: In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a condition to call a macro
for archival purposes, you should post your final solution. -- Don Guillett SalesAid Software "Darren" wrote in message ... The suggestions work fine thanks for the help -- Darren "Darren" wrote: In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able to extract the month and from that run a macro based on that months value eg If january run macro january if febuary run macro febuary and so on until december any suggestions on how I do this. Thanks -- Darren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting more than one condition and multiple ranges | Excel Discussion (Misc queries) | |||
Excel Macro call Word Macro with Parameters | Excel Programming | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
Setting Application.EnableEvents=True after Thisworkbook.Close call | Excel Programming | |||
Sending email via macro- setting the importance setting. | Excel Programming |