Dropdown list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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