SeanMcquade
12-03-2007, 10:10 PM
I have created a form and I need it to take the inputs compute a forumula and then output it into specified excel cells.
What code takes the output back to Excel?
Private Sub CommandButton1_Click()
End Sub
Private Sub CancelButton_Click()
' closes box
Unload userform1
End Sub
Private Sub cmdClearForm_Click()
'Clears the specified textboxes and comboxes
Me.TextBox1.Value = vbNullString
Me.CheckBox1.Value = False
Me.TextBox2.Value = vbNullString
Me.ComboBox1.Value = vbNullString
Me.Option1st.Value = True
End Sub
Private Sub ClearFormButton_Click()
End Sub
Private Sub ComboBox1_Change()
End Sub
Private Sub OptionButton3_Click()
End Sub
Private Sub OKButton_Click()
End Sub
Private Sub Option2nd_Click()
End Sub
Private Sub TextBox1_Change()
End Sub
Private Sub TextBox2_Change()
End Sub
Private Sub UserForm_Click()
End Sub
I realize that a lot of the buttons do not yet have attributes, that is because I am kind of struggling with assigning the buttons the forumula I am using.
Thanks for any Help
What code takes the output back to Excel?
Private Sub CommandButton1_Click()
End Sub
Private Sub CancelButton_Click()
' closes box
Unload userform1
End Sub
Private Sub cmdClearForm_Click()
'Clears the specified textboxes and comboxes
Me.TextBox1.Value = vbNullString
Me.CheckBox1.Value = False
Me.TextBox2.Value = vbNullString
Me.ComboBox1.Value = vbNullString
Me.Option1st.Value = True
End Sub
Private Sub ClearFormButton_Click()
End Sub
Private Sub ComboBox1_Change()
End Sub
Private Sub OptionButton3_Click()
End Sub
Private Sub OKButton_Click()
End Sub
Private Sub Option2nd_Click()
End Sub
Private Sub TextBox1_Change()
End Sub
Private Sub TextBox2_Change()
End Sub
Private Sub UserForm_Click()
End Sub
I realize that a lot of the buttons do not yet have attributes, that is because I am kind of struggling with assigning the buttons the forumula I am using.
Thanks for any Help