I am trying to create a drop down selection list to a command button based from a formula. Please see below for what I have so far.
Private Sub CommandButton2_Click()<o
></o
>
For X = 1 To Selection.Rows.Count<o
></o
>
n = Selection.Row + X - 1<o
></o
>
Selection.Range(Cells(X, 1), Cells(X,Selection.Columns.Count)) = "=M" & n &"*.012*(1+K2)"<o
></o
>
Next X<o
></o
>
<o
> </o
>
End Sub
My main goal is to be able to select an option from a drop down list, and post that information to a specific selected cell.
Private Sub CommandButton2_Click()<o


For X = 1 To Selection.Rows.Count<o


n = Selection.Row + X - 1<o


Selection.Range(Cells(X, 1), Cells(X,Selection.Columns.Count)) = "=M" & n &"*.012*(1+K2)"<o


Next X<o


<o


End Sub
My main goal is to be able to select an option from a drop down list, and post that information to a specific selected cell.