View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scottydel scottydel is offline
external usenet poster
 
Posts: 23
Default Using a ComboBox Control in Excel

Hello,

I'm using Excel 2003. I have added a combobox to Sheet1. I would like to
know how to access that control both from the code behind Sheet 1, as well as
another module in the Modules folder.

I am a little more used to Access VBA and Windows Forms, and there it is as
simple as something like:

Forms("formName").Controls("controlNname").Propert y/Method


I have used the object browser but haven't found a similar "Controls"
collection to locate my combo box.

Any help would be appreciated!

Thanks,

-Scott