Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing users to complete a form
I am setting up a form for to help calculate sales in the store I work
in. There are several managers who only enter enough data into the form to get the numbers to balance. They are leaving out other informatiun such as customer count, total credit transactions, "signatures" etc. I want to force them to put in all information before they can print or close the application. Is there any way to do this? Jeremy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing users to complete a form
to get you startes try: If Application.CountA(<your range) < <specify number Then Msgbox "Complete column before you can print..." End if david -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=485748 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing users to complete a form
In the particular control, say TextBox1.
Create an _Exit event, which look like this: Private Sub TextBox1_Exit (ByVal Cancel As MSForms.ReturnBoolean) if len(trim(UserForm1.TextBox1.Value))=0 Then msgbox "Invalid Input", vbCritical, "Error Message" Cancel = True end if End Sub As long as you set the value of the Cancel to TRUE, the user cannot get out of the TextBox1 input process. Hope this help you BoyP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing users to update spreadsheets | Excel Discussion (Misc queries) | |||
Forcing users to complete a form | Excel Discussion (Misc queries) | |||
Forcing users | Excel Programming | |||
Forcing users to enable macros | Excel Programming | |||
forcing complete calculation | Excel Programming |