Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forcing users to update spreadsheets DKerr Excel Discussion (Misc queries) 2 July 27th 06 12:55 PM
Forcing users to complete a form BK Excel Discussion (Misc queries) 3 November 22nd 05 12:35 AM
Forcing users M atthew J. Couture Excel Programming 1 April 4th 04 05:25 PM
Forcing users to enable macros universal[_17_] Excel Programming 8 December 20th 03 03:14 PM
forcing complete calculation Claude Excel Programming 6 October 21st 03 07:17 PM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"