Convert this IF and MIN formula into VBA

[mtilbury]

Hi
I'm trying to convert the following formula into VBA
'=IF(F35>F30,MIN((F35-F30),E30),0)

I have written the following code but 'iLimit is Blank when I step through the code. a, z and i as numbers in a textbox on a userform.
I have also tried Dim iLimit as a Variant too.

If I hover over a, z, i it shows the correct values. Its the iLimit that is not working. I think its the IF function??

Please Login or Register  to view this content.

[Norie]

There is no WorksheetFunction.If, either use Evaluate or use VBA's own If.

If you are using textboxes I would recommend the latter, can you post the textbox names and outline their relationship?

[protonLeah]

An option:

Please Login or Register  to view this content.

Another:

Please Login or Register  to view this content.

[Marc L]

Hi !

I'm trying to convert the following formula into VBA
'=IF(F35>F30,MIN((F35-F30),E30),0)

    iLimit = Evaluate("IF(F35>F30,MIN((F35-F30),E30),0)")  

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !