|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#2
08-21-2008, 01:12 AM
|
||||
|
||||
|
Hi michi, and welcome to the forum.
Macros are a form of programming that allows you to do some amazing things with Excel (and other Office programs) that would be difficult, if not impossible, to do otherwise. Here's something from Microsoft on 'what macros are and why you should care': http://office.microsoft.com/en-us/ex...256431033.aspx As for drop-down boxes, you technically can't use them to create macros, rather, you can use macros to create drop-down boxes, or act upon any change you make in a drop-down box. With macros you can add/change/remove items in a drop-down box list, run other macros based on the selections you make, etc.. Adding a drop-down box itself to your workbook is easy enough - click the Developer ribbon bar -> Insert (on the Controls menu) -> beneath ActiveX click on the combobox icon and then select an area on your worksheet. This creates the object, but obviously doesn't add any code (functionality) behind it. 
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Assign Multiple Macros to Drop Down List | rme8223 | Excel Programming | 2 | 07-18-2008 06:57 PM |
| Cell drop down and If formulas | Alsebiates | Excel - New Users | 1 | 11-02-2007 06:15 PM |
| From one drop down to another | derwood | Excel Programming | 5 | 04-09-2007 07:36 PM |
| Make 'drop down' list of Macros | harryhill | Excel Worksheet Functions | 1 | 01-17-2007 12:07 AM |
| But there are no macros! | Ms_Teacher | Excel Miscellaneous | 3 | 10-01-2006 09:27 PM |
Linear Mode
