View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Call a Control_Click Event when UserForm is Initialized

I have a UserForm with several CheckBoxes, TextBoxes, ComboBoxes, etc. I
also have a Command Button Click Event that calculates totals of everything.
I have the Controls in the UserForm autofilled by a worksheet and then call
the Userform. For example:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

''''code to autofill userform

UserForm.Show
End Sub

I want to insert some code to automatically call the commandbutton_click
event so all my totals will automatically be there and the user does not have
to click the command button, how do I do this?

Thanks for your help in advance!!