View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Combo Box Form Control

Hi Lambs -

Let's assume the name of the worksheet is "Lambs".

1. Press Alt+F11 to open the VB Editor.

2. In the Project Explorer pane on the left side of screen you should see
the Folder "Microsoft Excel Objects". Under that folder, you should see a
list of sheets in the workbook. Double-click on the "Lambs" sheet to open
its module (this is a worksheet module as opposed to a standard module listed
under the "Modules" folder. The purpose of worksheet modules is to hold
worksheet-specific code).

3. Paste the code (along with the 'Me' keyword) into the main window that
opened for the "Lambs" worksheet.

4. Switch back to the worksheet (Alt+F11) and test it out.

---
Jay