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
|