cpmurphy1144
07-27-2007, 11:12 AM
I have an Excel Workbook which contains several spreadsheets that I use to track data about our RV stock. I use command buttons and companion VBA code to allow users to enter data and assure that the data is placed in the correct locations on the worksheets.
In a few cases the set of possibilities for the acceptable entries in a given InputBox is relatively small (less than 50). I would like to implement a function which would suggest a complete entry once the user has typed enough characters to make the entry unique in a list of possible entries.
If anyone has done this or knows how I can acomplish this I would be very greatful for the information.
Thank you,
Pat Murphy
Poulsbo RV
In a few cases the set of possibilities for the acceptable entries in a given InputBox is relatively small (less than 50). I would like to implement a function which would suggest a complete entry once the user has typed enough characters to make the entry unique in a list of possible entries.
If anyone has done this or knows how I can acomplish this I would be very greatful for the information.
Thank you,
Pat Murphy
Poulsbo RV