Can Select Case be used to defined the Value of an item in a drop down list?

mbews · #5 10-07-2020, 11:52 PM

Appreciate the feedback so far. I've attached a sample version of just the controls that involve code. The only bit I need help with is the Client contact name row in the Contact Details box. Right now, how it works is that the Team Leader is selected which populates their mobile number to the right and their respective Senior Operative(s) in the drop down below.

The issue is that currently, when a Senior Op is selected, their name populates the mobile number field rather than their number because the code enters the Snr Op name in both Display Name and Value.

Is there a way to alter the code that it defines the Display Name and Value of a dropdown list item separately?

Many thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto create new worksheet when select option from drop down list	JANET JONG	Excel Programming	1	08-01-2018 07:13 AM
Select multiple items from a drop down list	ConfuddledOne	Excel Programming	0	01-30-2017 08:13 PM
Returning a specific value when item is selected from a drop-down list	J Press	Excel	4	09-10-2012 06:12 AM
Show the first item of a drop-down list instead of a blank	Pragabhava	Excel	1	12-29-2011 11:48 PM
Automatically select first item in drop-down?	flackend	Excel	4	08-29-2011 02:07 PM