Im trying to create a gui so my employees can update our inventory without having to touch the data. The program prompts them for all sorts of infomation. At the end i want it to take txtLocation, find it in the workbook and replace it with all data that has been entered(multiple cells). As of right now it just places the data in the next available of a very specific sheet.
Please Login or Register to view this content.
Last edited by Leith Ross; 06-16-2011 at 02:49 PM. Reason: Added Code Tags
Can't really test and amend this without workbook, worksheets, typical data, forms and code.
Please upload a sample workbook.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
sorry here is an example excel sheet.
Is there meant to be a data entry form and code in this workbook? Only there isn't.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks