A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Where is the Object section?



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 04:02 PM posted to microsoft.public.excel.misc
gudencough
external usenet poster
 
Posts: 8
Default Where is the Object section?

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?
  #2  
Old June 3rd, 2010, 04:16 PM posted to microsoft.public.excel.misc
Mike H
external usenet poster
 
Posts: 8,419
Default Where is the Object section?

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?

  #3  
Old June 3rd, 2010, 04:50 PM posted to microsoft.public.excel.misc
gudencough
external usenet poster
 
Posts: 8
Default Where is the Object section?

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?

  #4  
Old June 3rd, 2010, 05:01 PM posted to microsoft.public.excel.misc
Mike H
external usenet poster
 
Posts: 8,419
Default Where is the Object section?

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?

  #5  
Old June 3rd, 2010, 05:21 PM posted to microsoft.public.excel.misc
gudencough
external usenet poster
 
Posts: 8
Default Where is the Object section?

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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.