VBA Intellisense

[Looch]

I've added a combo box to an excel sheet and when I open up the VB
editor and try to add items, etc., it does not show up in the
intellisense. I tried me.cmbTest and nothing. I set the worksheet = ws
and tried ws.cmbTest and still nothing. The box is definately there,
I've tried saving the form before programming it and it still goes
unnoticed. Am I missing something obvious? Thanks for any help.

 

[Norman Jones]

Hi Looch,

To obtain the intellisense, in the userform (or the
sheet) module, try replacing

.cmbTest

with

Me.cmbTest

 

[NickHK]

Assuming that you are actually on the correct worksheet module (so Me refers
the correct WS), Intellisense can fail if you have errors in your code.
Debug>Compile, fix any errors found, then see if it comes back.

NickHK