View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default using a worksheet range to populate a combo box in excel

Hi Kev,

in VBA window you should see window called immediate, otherwise go to
view immediate window.

When the code stops at the breakpoint (the application will bring you
to vbe window), you should see the line of code with yellow background
and should be able to execute commands from previous post in immediate
window (just copy and paste them, you need to press enter at each row
of code to execute the row in immediate window).

You need to click on your userform at "cboPartsused" to fire event
"Private Sub cboPartsused_Click" - the breakpoint is inside this event
procedure.

Regards,
Ivan