| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm with Cell Data
I have a CommandButton bringing up a UserForm. On that
form, I want to display the contents of three cells, and then display the sum of the other three cells. How do I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm with Cell Data
private Sub CommandButton1_click()
With userform1 .Textbox1.Value = Range("A1").Text .Textbox2.Value = Range("A2").Text .Textbox3.Value = Range("A3").Text .Textbox3.Value = Application.Sum(Range("A1:A3")) .Show End With end Sub -- Regards, Tom Ogilvy Phil Hageman wrote in message ... I have a CommandButton bringing up a UserForm. On that form, I want to display the contents of three cells, and then display the sum of the other three cells. How do I do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Thank You
Thanks, Tom - works fine!
-----Original Message----- private Sub CommandButton1_click() With userform1 .Textbox1.Value = Range("A1").Text .Textbox2.Value = Range("A2").Text .Textbox3.Value = Range("A3").Text .Textbox3.Value = Application.Sum(Range("A1:A3")) .Show End With end Sub -- Regards, Tom Ogilvy Phil Hageman wrote in message ... I have a CommandButton bringing up a UserForm. On that form, I want to display the contents of three cells, and then display the sum of the other three cells. How do I do this? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform that add data in all w/sheets | Excel Discussion (Misc queries) | |||
| Userform data | Excel Discussion (Misc queries) | |||
| Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
| Use a UserForm to preview data | Excel Programming | |||
| Taking Data of cell from worksheet to a userform window | Excel Programming | |||
Linear Mode
