Juan Velasquez
asked on
Need Help implementing autocomplete on data validation drop down
Hello,
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 ntTypeCode 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 ymentTypeC ode(Target ) 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.
Timesheet-v1-23.xlsm
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
Timesheet-v1-23.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello fanpages.
Actually the user only needs to see the description during the selection process. The reason that only the code is stored is because the data on the worksheet will be exported via a csv file to another application (Spectrum) whose file input requirements are that only the codes will be imported
Actually the user only needs to see the description during the selection process. The reason that only the code is stored is because the data on the worksheet will be exported via a csv file to another application (Spectrum) whose file input requirements are that only the codes will be imported
ASKER
Thanks for the advice
ASKER
I cannot use Active x Box controls since the number of rows will be dynamic. For instance, there can be multiple entries for the same date, having different payment types. As for the the initial letter of the code, what is being entered, upon entering the hours is the actual payment code.