Use Numerical Value from a TextBox as Input for a Formula

Hello Excel experts,


I want to know what I Need to do declare and use a TextBox I want to add in a UserForm, so that the numerical value entered in this field will be the value to use for a formula.

This is the Code for the calculation:

With Cells(1, Columns.Count).End(xlToLeft).Offset(, 1)
.Resize(, 2).Value = Array("Average", "25% Average")
.Offset(1, 0).Resize(LastRow - 1).FormulaR1C1 = "=AVERAGE(RC2:RC[-1])"
.Offset(1, 1).Resize(LastRow - 1).FormulaR1C1 = "=RC[-1]*REFERENCEVALUE"
.Resize(, 2).EntireColumn.NumberFormat = "0.0000"
End With


I would like the user to be able to modify the value that will multiply RC[-1], that means "REFERENCEVALUE".
So the question is, how can I create the TextBox that will give me the value "REFERENCEVALUE" that the user can enter?

Thank you very much in advance and I hope I was clear enough.

Jorge

Hello,

Could you please explain me more?
I didnt quite get it.

It is not an Input box what I want to do, but being able to Input that reference value via TextBox in a UserForm.

I tried to just Change the TextBox Name to txtRefNo and give t a try but it doesnt work.

The Code for that calculation is not in the Userform but in a Module, does that have something to do?

There are many Things I still dont get since Ive just been learning myself recently.

Thanks again,
Jorge

I am sorry about that. Will not happen from now on!

Jorge

I Dont know why but it still does not work, I get an error on this line:

Please Login or Register  to view this content.

The UserForm is called UserForm1 and TextBox is called txtRefNo.

Is this the correct way to "declare" the TextBox and what happens when the user Inputs info?

Please Login or Register  to view this content.

Thanks again and sorry for being such a pain. but ist a Project that could really get me some Points at work to get a full time contract.

Jorge

Hello Norie,

I already deleted the Code for the TextBox

Please Login or Register  to view this content.

and the error I get is Error 1004 "Application-defined or Object-defined error", marking the line:

Please Login or Register  to view this content.

I dont know what else I could try then.

Hello Norie, I just attached a sample of the file.

I think a short Explanation might help. Each column is a solar panek, each row is a date/time and values are for curent that the Panel generates. The reason of my Project is to get the average of every line and then multiply that average
times a value the user can enter (the TextBox in the UserForm) this to find the Panels that provide less current than
some references that we have.

The line that Shows the error is in Module 1.

I really appreciate your help.
Jorge

Hello Norie,

Sorry to bother you, did you have by any Chance the opportunity to take a look at the file?

Thank you very much in advance.

Jorge

Hello again Norie!

Thank you for your responde, sorry if I sound too ignorant... what does "called" from the userform mean? That the sub Averages code is in the Userform Module?

Jorge