Reply to thread

Message: [QUOTE="Sam Kuo, post: 6325772"] Hi Tim I tried using the range address to assign ControlSource to a textbox, as you and JLGWhiz suggested. The cell value now changes whenever the textbox value changes, but NOT vice versa (i.e. the textbox value does not update to reflect any changes made to the cell, except for the first time that the cell value changes after form initialization). I guess this is because the SetControlSource subroutine runs at form initialization?? Is there a way to ensure the textbox value always updates whenever its control source value changes? Sam [/QUOTE]