Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Questions
Hello World
User enters data into a form control for the purpose of generating a manifest. I want to stop the user from entering more than 30 products within a single userform. The controls are linked to a worksheet called "Temp". Also on the same userform I want to be able to tell the user if any information is missing for instance this code executes the msgbox but then procedes with the rest of the code? Sub Name() Sheets("TEMP").Select If Range("E40") = "-" Then 'Relates to a cell where information is copied from into. "-" = product code seperator. MsgBox "You must enter a Product Code!", vbInformation End If User_InputP.Show 'Userform for entering products. 'rest of code to copy and paste information into a table TIA Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
questions about at sum | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Two questions | Excel Discussion (Misc queries) | |||
VB questions | Excel Programming |