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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Difficulty with compatibility mode and Track Changes 2
Dropdown with signatures 1
Calculation Based on Dynamic Variables (What-if Scenario) 0
Access Backstage Reset DropDowns 0
How to populate other fields when a dropdown was changed 13
Create own tool bar Mac 2015 0

Top