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
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