Combo boxes

[Zone]

I need to study up on combo boxes. Anyone have any links to good sites on
this? Thanks, James

 

[Jim Cone]

The O'Reilly book "Visual Basic Controls in a Nutshell" (Evan S. Dictor)
has been of some help to me over the years.
Amazon has used copies for $1.65 + shipping.
http://tinyurl.com/2wj6vc
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Zone" <[email protected]>
wrote in message
I need to study up on combo boxes.
Anyone have any links to good sites on this?
Thanks, James

 

[Guest]

if you mean the comboboxes that come with Excel:

These are on using Userforms, but at least in the first, comboboxes are
discussed as well.

http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms


http://j-walk.com/ss/excel/tips/tip84.htm

http://www.contextures.on.ca/xlUserForm01.html


See this tutorial here
http://www.dicks-blog.com/excel/2004/09/linking_userfor.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

I think after you have the basics, the rest is reading the help file on the
various properties.

 

[Zone]

Thanks, Tom and Jim!

if you mean the comboboxes that come with Excel:

These are on using Userforms, but at least in the first, comboboxes are
discussed as well.

http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms


http://j-walk.com/ss/excel/tips/tip84.htm

http://www.contextures.on.ca/xlUserForm01.html


See this tutorial here
http://www.dicks-blog.com/excel/2004/09/linking_userfor.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

I think after you have the basics, the rest is reading the help file on
the
various properties.