Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
I want to assign a macro to an if statement. After I've recorded the macro,
how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
May as well put the If into your VB.
Wherever the macro is, Private Sub macroname() 'comments Put your IF x Then Macro code End If End Sub "JHusker" wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
You can't (reliably) run a macro from a worksheet cell. A cell can
call upon a function written in VBA, but that function cannot change any part of the Excel environment, such as changing the value of another cell. A function called from a worksheet cell (directly or indirectly) can only return a value to the cell from which it was called. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Fri, 10 Oct 2008 13:38:08 -0700, JHusker wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
Macros can not be assigned to a formula.
You can use User Defined Function to a formula... "JHusker" wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
This is what I want to do:
if the value of the cell=0, then I want the whole row to be hidden......is this possible? "Chip Pearson" wrote: You can't (reliably) run a macro from a worksheet cell. A cell can call upon a function written in VBA, but that function cannot change any part of the Excel environment, such as changing the value of another cell. A function called from a worksheet cell (directly or indirectly) can only return a value to the cell from which it was called. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Fri, 10 Oct 2008 13:38:08 -0700, JHusker wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
How do you write an IF into VB?
"Sean Timmons" wrote: May as well put the If into your VB. Wherever the macro is, Private Sub macroname() 'comments Put your IF x Then Macro code End If End Sub "JHusker" wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
In the Sheet's code module, use code like the following. Change the
tests of the row numbers to reflect the row(s) whose values you want to test: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub End If If Target.Row = 11 And Target.Row <= 15 Then If Target.Value = 0 Then Target.EntireRow.Hidden = True Else Target.EntireRow.Hidden = False End If End If End Sub Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Fri, 10 Oct 2008 13:53:01 -0700, JHusker wrote: This is what I want to do: if the value of the cell=0, then I want the whole row to be hidden......is this possible? "Chip Pearson" wrote: You can't (reliably) run a macro from a worksheet cell. A cell can call upon a function written in VBA, but that function cannot change any part of the Excel environment, such as changing the value of another cell. A function called from a worksheet cell (directly or indirectly) can only return a value to the cell from which it was called. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Fri, 10 Oct 2008 13:38:08 -0700, JHusker wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to If Statement
It is possible. I suppose you'd want the code. :-(
You would probably get best results in the Excel Programming section... I know you'd want to use soemthign such as If Range("A1).Value = 0 Then Selection.entireRow.Hidden End If But not sure of the function this would require... "JHusker" wrote: This is what I want to do: if the value of the cell=0, then I want the whole row to be hidden......is this possible? "Chip Pearson" wrote: You can't (reliably) run a macro from a worksheet cell. A cell can call upon a function written in VBA, but that function cannot change any part of the Excel environment, such as changing the value of another cell. A function called from a worksheet cell (directly or indirectly) can only return a value to the cell from which it was called. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Fri, 10 Oct 2008 13:38:08 -0700, JHusker wrote: I want to assign a macro to an if statement. After I've recorded the macro, how do I assign it to the "=if" formula? Thanks in advance for the help! ~Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro if and / or statement | Excel Discussion (Misc queries) | |||
If statement in macro | Excel Discussion (Misc queries) | |||
can i use an IF Statement to run a macro? | Excel Worksheet Functions | |||
if statement in Macro | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) |