Methods of user entry
Hey everyone,
At the moment I have a drop down list where users can select a meal from a table and then a vlookup formula to find the calorie content.
This is time consuming as users have to scroll through tons of foods to find theirs, is there an easier method of having them input the food they have eaten and then excel to show the calories?
Cheers,
Adam
You could group them into type of food and use dependent data validation lists maybe.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks