Intellisense practically not working.

Question

I'm trying to write VBA macro for Excel 2010. I used to have functional intellisense with older version of office but now it is practically not working.

For example if I type:

**Sub Test()  Worksheets(**At this point I got intellisense giving me help that function need index. So I keep writing:

Worksheets(1).

After "dot" nothing happens. Nothing shows up of what I could select. And this is typical for practically every object. I can for example write:

Worksheets("Sheet1").Range("A1").

and again after "dot" I'm getting nothing. However there is no bug in the surboutine. For example if I wrtie complete subroutine:

Sub Test()  Worksheets(1).Range("A1").Value = 20End Sub

and run it, it runs perfect without any error message and does fill cell A1 with the value of 20. However editing second line of the above code after the run still does not brings up intellisense.

One more info is that when I put cursor over the object such as Range or Worksheet and press F2 the object explorer comes up with full info about the object under the cursor so the library is clearly loaded.

HELP, what is wrong that I do not have working intellisense ?

Jack

Answer 1

I recommend using:

Sub Test()

    Dim wb As Worksheet

    wb.Range("A1").Value = 10

End Sub

The intellisense will be fully functional.

Answer 2

Oh yes, thank you OssieMac. Also, it is recommended using ws for naming a Worksheet than wb.

Answer 3

Felipe Benza omitted a line in the example.

Sub Test()

   Dim wb As Worksheet

   Set wb = Worksheets("Sheet1")

   wb.Range("A1").Value = 10

End Sub

---

Regards, OssieMac