| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dropdown list
Hi, I am a beginner, I have a question. I insert a form dropdown list to a
Excel file, how can I use(reference) it in my code? Thanks a lot!! Cyrus |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Dropdown list
When you format the control, in the control tab, you can select input range
and cell link. You can use cell link, for example A1, in you VBA code or excel formula to capture the values of the dropdown list. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Cyrus" wrote in message ... Hi, I am a beginner, I have a question. I insert a form dropdown list to a Excel file, how can I use(reference) it in my code? Thanks a lot!! Cyrus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
| How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
| Entering data from dropdown list | Excel Discussion (Misc queries) | |||
| HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
| How to show dropdown list from another workbook without running it | Excel Discussion (Misc queries) | |||
Hybrid Mode
