1) In VBA Editor, insert a new UserForm to your project
2) On the userform, place two text boxes. (Their names are "TextBox1" and "TextBox2" for example)
3) Place one Label. (It name is "Label1" for example)
4) Place one command button (It name is "CommandButton1" for example)
5) Double-click the command button to insert some code
Private Sub CommandButton1_Click()
Label1.Caption = TextBox1.Value + TextBox2.Value
End Sub
----- Xispo wrote: -----
I am trying to make a simple form calculator!
2 Textboxes, and then when I click a button another textbox displays
the sum of the 2 textboxes.
How do I do this? Does the answer need to appear in a label or
textbox?
I think I need to have a button so that the form refreshes and I get
the answer, is this the case??
thanks
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/