VBA Intellisense

  • Thread starter Thread starter Looch
  • Start date Start date
L

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.
 
Hi Looch,

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

.cmbTest

with

Me.cmbTest
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem in adding macro to ribbon through Add-in 7
Properties with Intellisense 1
Getting correct labels in Excel pivot 2
Placing the MsgBox "No ID found" statement in my code?? 12
Excel VBA 1
For Each minor problem 7
Find dupes, list in MsgBox with cell.address convert ws wide code toone sheet 6
Excel Move or Copy Stopped Working? 0

Back
Top