Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok, here's the deal. I have 2 macro's currently. the first to call the
user form where the user will input a minimum ammount, maximum ammount, and the increment in which they want to use. I have the code for the calculations done, I just need help passing the variables from the userform to the second macro as numeric values. All of my code is posted below. Any help would be appreciated. Thanks in advance. Andrew MACRO 1 Public Sub tax() Dim increment As String Dim min As Double Dim max As Double UserForm1.Show End Sub USERFORM Public Sub IncBox_Change() increment = IncBox increment.Value = Val(txtNumber.Text) End Sub Public Sub MaxBox_Change() max = MaxBox increment.Value = Val(txtNumber.Text) End Sub Public Sub MinBox_Change() min = MinBox increment.Value = Val(txtNumber.Text) End Sub Private Sub OKButton_Click() UserForm1.Hide Application.Run ("Calculations") End Sub Private Sub UserForm_Click() End Sub MACRO 2 Sub Calculations() ' ' ' Dim rowcounter As Integer rowcounter = 40 income = min Do While income <= max Range("b" & rowcounter).Select ActiveCell.FormulaR1C1 = income Selection.Copy Range("B1").Select ActiveSheet.Paste Range("G16").Select Application.CutCopyMode = False Selection.Copy Range("D" & rowcounter).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("G25").Select Application.CutCopyMode = False Selection.Copy Range("C" & rowcounter).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("E" & rowcounter).Select ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-2]" Range("F" & rowcounter).Select ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]" income = income + increment rowcounter = rowcounter + 1 Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
check is input textboxes is numeric on userform | Excel Programming | |||
Ensuring UserForm Textbox Entry is numeric | Excel Programming | |||
Use numeric data from a textbox on an userform | Excel Programming |