Refreshing a text box

[nicbrez]

I have a sheet in which there are several dropdown selection boxes with parameters for the user to select and an output text box, which contains a sum that results from the parameter selection.

When a user changes a parameter, i have a macro which updates values in another sheet and which should update the value in the output text box.

However when i change a parameter the output text box doesnt update the new value. I have linked the box to the sheet cell (LinkedCell). How do i give the box a 'kick' so that it displays the latest value?

Cheers

Nic

 

[sykes]

Hi
A bit more explaination would be helpful.
Please show the code in your macro.