Hi all, below is my code.

Sheets:
'Calcrts' - contains a table of data. The range is A2:C97
'Ticker Converter' - contains three cell ranges for user inputs.

How it should work:
The user should be able to change any single input field and have the other two fields automatically populate with the corresponding data housed in the other sheet.

Problem:
I am trying to use the Select Case loop in conjunction with the 'SelectionChange' Event Procedure. When I change one of the input fields to 'ABC', I would expect the other two fields to show '123' and 'XYZ'. Instead, all three just go blank.

Any suggestions? Thanks!

Please Login or Register  to view this content.