I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does anyone know where it is?

Hi,

Maybe it would be best to explain what your trying to do.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does anyone know where it is?

This is from an earlier question i asked but have not been able to get back
to it.
I need to insert this command into excel:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculatefull
End Sub

However they said to insert it into the Microsoft Excel Object (section) in
the same sheet i have the calculations, instead of a module.

However, I don't understand what or where the Excel Object (section) is.

"Mike H" wrote:

Hi,

Maybe it would be best to explain what your trying to do.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does anyone know where it is?

Hi,

That's worksheet event code. Right click the sheet tab that you want to call
this from, View code and paste that code in on the right. Now if you change
cell in that worksheet the workbook will calculate. I haven't seen your other
question and no doubt there's a good reason for calculating this often but it
could slow your worksheet down considerably if it has lots of formula.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

This is from an earlier question i asked but have not been able to get back
to it.
I need to insert this command into excel:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculatefull
End Sub

However they said to insert it into the Microsoft Excel Object (section) in
the same sheet i have the calculations, instead of a module.

However, I don't understand what or where the Excel Object (section) is.

"Mike H" wrote:

Hi,

Maybe it would be best to explain what your trying to do.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does anyone know where it is?

This works excelent. Thank you. I've looked at that tab in the visual basic
many times but it never clicked in my head. There are a lot of potential
calculations in the worksheet but only a few are needed now. So it may slow
it down in the future but as for now there is no delay.
Thanks again

"Mike H" wrote:

Hi,

That's worksheet event code. Right click the sheet tab that you want to call
this from, View code and paste that code in on the right. Now if you change
cell in that worksheet the workbook will calculate. I haven't seen your other
question and no doubt there's a good reason for calculating this often but it
could slow your worksheet down considerably if it has lots of formula.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

This is from an earlier question i asked but have not been able to get back
to it.
I need to insert this command into excel:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculatefull
End Sub

However they said to insert it into the Microsoft Excel Object (section) in
the same sheet i have the calculations, instead of a module.

However, I don't understand what or where the Excel Object (section) is.

"Mike H" wrote:

Hi,

Maybe it would be best to explain what your trying to do.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"gudencough" wrote:

I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does anyone know where it is?