Round up a figure from VLookUp in VBA userform textbox

[RJSIGKITS]

Hey guys.
Is it possible to RoundUp the figure returned in my textbox (Price) to be a whole round number?
For example, I want '113.2184', to roundup to '114'

Price = Application.WorksheetFunction.VLookup(TextBox1.Text, Range("AllProds2"), 10, 0)

I don't mind if it rounds up to:
'114'
or
'114.00'

Cheers in advance.

 

[Nine Zero]

Hey guys.
Is it possible to RoundUp the figure returned in my textbox (Price) to be a whole round number?
For example, I want '113.2184', to roundup to '114'

Price = Application.WorksheetFunction.VLookup(TextBox1.Text, Range("AllProds2"), 10, 0)

I don't mind if it rounds up to:
'114'
or
'114.00'

Cheers in advance.

Try maybe wrapping it in CInt() like this

Price = [COLOR=#ff0000]CInt([/COLOR]Application.WorksheetFunction.VLookup(TextBox1.Text, Range("AllProds2"), 10, 0)[COLOR=#ff0000])[/COLOR]

 

[RJSIGKITS]

Perfecto!
Thanks!

 

[Nine Zero]

No problem, glad to help.