the button on the total tab should open a form that should have item Quantity Lot number location and description. form pulls up but getting error when data is entered.
what I want is the item to have a drop down that pulls its data from the product tab
and the location have a drop down that has wh1 wh2 wh3 wh4 the data will be placed in the sheet that is selected
You have several naming errors in your code:
Set ws = Worksheets("wh"), but there is no sheet "wh"
txtItem is a label, the textbox is TextBox1, etc. In fact you seem to be using the label names in place of the textbox names throughout the code.
Last edited by protonLeah; 11-14-2010 at 04:04 PM.
Ben Van Johnson
Thanks for the help! i am very new to this and i am confused on how i need to finnish this. do you have any sussestion on how i need to fix this?
Change the code to match the correct controls, sheets etc.
Use Option Explicit to avoid mistakes like this, do some reading on basic VBA coding
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks