In the attached workbook, I have two worksheets. Worksheet non combo employs a straight data validation on the payment type column. If you enter 8 hours in the hours worked column, the corresponding payment type is set to R. You can then select a different payment type via the data validation drop-down list. The selection is then processed by the Call basExcelUtilities.SetPayme
procedure in the worksheet change event which then retrieves the correct code to populate the payment type cell. However, the customer wants me to employe auto completion in the data validation cells. I did some research and found code at http://www.contextures.com/xlDataVal11.html
that would allow me to do that. The code does partially work in that the selected value from the combo box is displayed in the cell. I'm trying to figure out how to replace the displayed value with its code via thebasExcelUtilities.SetPa
) procedure. This can be seen in the worksheet WTS_Combo. I've tried placing the call to that procedure in the Worksheet_SelectionChange event but it's still not working the way I want.