Hi all,
I'm creating an input sheet for a friend using Excel to simplify the collection of data. I have a list box set up in a set of cells which contains a listing of codes. What my friend wants is for the inputter to be able to choose one of these codes, but for the return value in that cell to be the adjacent column value from the list.
List:
Code Value
1 Monday
2 Tuesday
3 Wednesday
What you see in the cell list is 1, 2, 3 etc, but when you choose one of these values, that the day of the week would be returned.
Is this possible using VBA? The Excel listbox only allows 1 column of data.
Help appreciated.
rgs
Ginny
I'm creating an input sheet for a friend using Excel to simplify the collection of data. I have a list box set up in a set of cells which contains a listing of codes. What my friend wants is for the inputter to be able to choose one of these codes, but for the return value in that cell to be the adjacent column value from the list.
List:
Code Value
1 Monday
2 Tuesday
3 Wednesday
What you see in the cell list is 1, 2, 3 etc, but when you choose one of these values, that the day of the week would be returned.
Is this possible using VBA? The Excel listbox only allows 1 column of data.
Help appreciated.
rgs
Ginny
