This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is it possible to enter a formula into a textbox on a userform? I have several other text boxes into which values are inserted, I want another textbox to multiply all the other values together and display the result on the userform and enter it into a cell in my worksheet.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
No, you can't enter a formula in a text box on a userform. Use the After Update event of each of the contributing text boxes to recalculate the product and place the result in another text box. If you set the ControlSource property of that text box to a cell on the worksheet, the cell value will be updated automatically.