Thread: Require user to enter numeric value in TextBox
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
  
Posts: 449
Default Require user to enter numeric value in TextBox
Disable the button from the very beginnig. In design time, or in the
userform_initialize event:

Commandbutton1.Enabled = False


Reply With QuoteReply With Quote