initialize是窗体初始化期间完成的事件 activate是窗体初始化完成后处于激活状态时的事件
Is there a possiblity to directly get the textbox3 value instead of clicking a button? So if textbox1.value <>0 & textbox2.value<>0 then textbox3 = sub()- I had added button just for testing. NewBInVB Saturday, November 5, 2016 8:18 AM ...
Private Sub userform1_activate()Application.ScreenUpdating = FalseTextBox1.SetFocusmm = FalseApplication.ScreenUpdating = TrueEnd SubPrivate Sub userform1_queryclose(Cancel As Integer, CloseMode As Integer)If Not mm ThenThisWorkbook.Application.QuitEnd SubPrivate Sub CommandButton2_Click()ThisWorkbook....