Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Userrange to formula
Dear all,
I am new with the VBA part of Excel but I want to learn the language. Now I came up with the following problem. I want a pop upbox where the user can select a range and after pressing ok this should be converted to a formula in cell c1 (formula= "=sum(selected range)"). Now I have this: Sub Test() Set UserRange = Application.InputBox("Hallo", "Select your range:") Rng = Application.WorksheetFunction.Sum(UserRange) Range("C1").Select Selection.Value = Rng End Sub After the popup it stops. Most likely because I misuse the Sum function but I couldn't find out a solution. Can someone help me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userrange to formula
Hi,
Am Wed, 10 Apr 2013 14:00:15 +0000 schrieb Klaasv: Now I have this: Sub Test() Set UserRange = Application.InputBox("Hallo", "Select your range:") Rng = Application.WorksheetFunction.Sum(UserRange) Range("C1").Select Selection.Value = Rng End Sub try: Sub Test() Dim UserRange As Range Set UserRange = Application.InputBox("Hallo", _ "Select your range:", Type:=8) If Not UserRange Is Nothing Then [C1] = WorksheetFunction.Sum(UserRange) End If End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |