How to turn on Intelisense for Excel objects in VB?

[jofarrell]

I am exporting to an Excel spreadsheet and have never done it before nor have I played much more than the basics of a spreadsheet. It would be nice if VB (like it does for most everything else) listed some properties after I typed. For example:
objResultsSheet.Cells(Y, 1).????? would probably give me a list with Value, Formula etc .. things I am picking up are from past threads and these vries for help So anyone know a way I can just get VB to give me the Excel object properties?

Joanne

 

[Morpheus1981]

Well Maybe I am missunderstandig your question. Because when a I created a program that sent information to microsoft word I had intellicense as also a list of properties for procedures and functions.
Maybe ur problem is the way u create ur object, because if u use CREATEOBEJECT("Application.Excel&quot or something like that u r no able to see properties, but if u declare a variable for example oExcel as Excel.Application or something like (I am not so that sure if that is the right name). Anyway U will be able to see Intellicense and all that.
I hope that helps