Dears,
One small question follows: after changing the number in Column A into
Text, the response of writing back the data from the user form to the
worksheet becomes slow.
My worksheet contains about 55 columns. A user form reads each cell
value of particular row to the textboxes. There is a save button to
write textboxes value back to the row using the code like:
Working_Order.Cells(1, 1) = TEXTBOX1.Value
Working_Order.Cells(1, 2) = TEXTBOX2.Value
...
..
where Working_Order is a Range of that row.
Before changing the column A into Text, I got instant response after I
click the Save button.
However, after changing the Column A into Text, I have to wait for
about 5~7 seconds to get back the control of userform after the Save
button is clicked.
Any idea what cause such delay?
Thanks
--
boris_lui
------------------------------------------------------------------------
boris_lui's Profile:
http://www.excelforum.com/member.php...o&userid=28489
View this thread:
http://www.excelforum.com/showthread...hreadid=481714