roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,062
- Office Version
- 365
- Platform
- Windows
- MacOS
have created a travel voucher form that has a 1300+ list of data of virtually every city in the country, many with multiple entries such as:
WILLIAMSBURG, VIRGINIA, 1 Apr through 31 Aug
WILLIAMSBURG, VIRGINIA, 1 Sep through 31 Mar
For each day traveled (from 1 day to 4 weeks, where each day can be a different location) , the user inputs the travel location by clicking on the data validation list box drop arrow in the cell that matches the travel day and selects the travel location from the list (it uses a VLOOKUP table to output the $$ he gets for that location and time of year).
However, the validation box is limited in that (1) you can't see the entire line (the input cell is wrapped but the list box cannot do that) and (2) the user can't go straight to the city by typing but is limited to scrolling only.
I would prefer to build a entry method that:
(1) shows the whole width of the entry (probably easily handled via a combo box but it has been a LONG time since I have used a combo box);
(2) be able to begin typing the entry (in this case "w", "wi", "wil" etc) and the list is filtered to match the starting letters
(3) places the result in the same cell from which I ran the routine, and
(4) is initiated as easily as a validation box (a command button just above each possible input cell?)
Thanks!
WILLIAMSBURG, VIRGINIA, 1 Apr through 31 Aug
WILLIAMSBURG, VIRGINIA, 1 Sep through 31 Mar
For each day traveled (from 1 day to 4 weeks, where each day can be a different location) , the user inputs the travel location by clicking on the data validation list box drop arrow in the cell that matches the travel day and selects the travel location from the list (it uses a VLOOKUP table to output the $$ he gets for that location and time of year).
However, the validation box is limited in that (1) you can't see the entire line (the input cell is wrapped but the list box cannot do that) and (2) the user can't go straight to the city by typing but is limited to scrolling only.
I would prefer to build a entry method that:
(1) shows the whole width of the entry (probably easily handled via a combo box but it has been a LONG time since I have used a combo box);
(2) be able to begin typing the entry (in this case "w", "wi", "wil" etc) and the list is filtered to match the starting letters
(3) places the result in the same cell from which I ran the routine, and
(4) is initiated as easily as a validation box (a command button just above each possible input cell?)
Thanks!