Updating textbox with value in userform

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have a textbox on my userform which i am trying to get
to show the running total based on the other options
selected on the form. At the moment it does not update - i
have set the control source to be the relevant value on my
spreadsheet, and even put in a command button which when
clicked would set the textbox value to equal this cell,
but i am getting no joy. Help is appreciated greatly here!

Thanks

Richard
 
At the moment it does not update

See if setting Calculation to Automatic helps, or add an
Application.Calculate to the macro.

It might be better not to involve the worksheet at all, if possible. No
Control Source, and do the calculation of the text box's value in the macro.

--
Jim Rech
Excel MVP
|I have a textbox on my userform which i am trying to get
| to show the running total based on the other options
| selected on the form. At the moment it does not update - i
| have set the control source to be the relevant value on my
| spreadsheet, and even put in a command button which when
| clicked would set the textbox value to equal this cell,
| but i am getting no joy. Help is appreciated greatly here!
|
| Thanks
|
| Richard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Userform Textbox to Worksheet Textbox 1
referring to a textbox on a different userform. 2
Formula in userform textbox 1
Copy value of textbox to clipboard for use in another application 5
Calendar and userforms 2
Counting TextBox values 1
Set value of all Userform textboxes to "" 4

Back
Top