Intellisense
 

What is Intellisense and where can I learn more about it?

Thank you

Intellisense
 

Did you try google?

http://tinyurl.com/rm997

--
Don Guillett
SalesAid Software

"Sandy" wrote in message
...
What is Intellisense and where can I learn more about it?

Thank you

Intellisense
 

Hi Sandy,

there isn't much to learn about it.

Dim oWrk As Workbook
With oWrk
.[suggestions, intellisense]
End With

Though Excel's demands for precise declaration
are higher as e.g. Word's demands.

Dim oWrk As Workbook
With oWrk
.Worksheets(1).[no suggestions, no intellisense]
End With

As opposite to:

Dim oWrk As Workbook
Dim oSht As Worksheet
Set oSht = oWrk.Worksheets(1)
With oSht
.[suggestions, intellisense]
End With

IMHO
HTH

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Intellisense
 

.Worksheets(1).[no suggestions, no intellisense]

The reason is that that Item method of Worksheets returns a
generic Object rather than a Worksheet type variable, even though
at run time it will always return a Worksheet object. Poor
typelib design by Microsoft.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Helmut Weber" wrote in message
...
Hi Sandy,

there isn't much to learn about it.

Dim oWrk As Workbook
With oWrk
.[suggestions, intellisense]
End With

Though Excel's demands for precise declaration
are higher as e.g. Word's demands.

Dim oWrk As Workbook
With oWrk
.Worksheets(1).[no suggestions, no intellisense]
End With

As opposite to:

Dim oWrk As Workbook
Dim oSht As Worksheet
Set oSht = oWrk.Worksheets(1)
With oSht
.[suggestions, intellisense]
End With

IMHO
HTH

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"