TextBox Value to be pasted in a cell after performing Sum

[arijitirf]

Hi!
Is there any way to get sum of the Textbox 1 value to be pasted in a cell.

my current vba lines are

Sheet3.Range("BJ" & Activecell.Row -1) = UserForm10.Textbox1.Value

I want to fill the textbox1 like "21+30+4+5" and want it to be pasted in the Activecell.Row -1 as sum of 21+30+4+5=60

OR

Is there any way to calculate that particular cell where the value of textbox1 is appearing as "21+30+4+5" so that the cell value is appeared as sum of "21+30+4+5" as 60

I cannot upload XL2BB due to certain limitation is set by my organization. Using Excel 2021

Thanks in advance.

 

[DanteAmor]

Try:

Sheet3.Range("BJ" & ActiveCell.Row - 1) = Evaluate(UserForm10.TextBox1.Value)

 

[arijitirf]

Try:

Sheet3.Range("BJ" & ActiveCell.Row - 1) = Evaluate(UserForm10.TextBox1.Value)

Wonderful! Thank you so much Mr. Amor.