Dropdown list

C

Cyrus

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
 
D

Daniel CHEN

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
=================================
 
Top