Update a worksheet cell from a textbox in real time
Posted on 2012-09-22
Sorry if there is a very obvious solution to this question that I am missing.
I have a userform that uses textboxes to change the values of cells in a workbook before running a series of macros from a commandbutton. I am using ControlSource to link the cells and textboxes but I have noticed that with this property the cell does not get updated until you move out of the textbox and select another textbox.
The problem is that if I press the commandbutton to run the macros while a textbox still has the focus, the target cell has not yet been updated (because I am still in the textbox).
Is there any way to update the cell in real time, i.e. so that it changes as you type into the textbox?
I know this can be done using the textbox change event, but this would mean writing change event code for about 300 textboxes (about 60 per page across 5 tabs in a multipage).
So, is there any other (less code intensive) way of making sure the last textbox entry is written to the cell before I run the macros?