9

VBA rewrite textbox with former value.

view full story
linux-howto

http://forum.allaboutcircuits.com – VBA Excel In a user form, the spin button brings a value up and down between 1 and 32. Value is shown in the textbox. The user is given the possibility of typing the value directly in the textbox. The code rejects it, if out of range, but fails to rewrite the old (good) one in the textbox to make evident that the last typed was not accepted. Code: Option Explicit     Const TTR_val_max As Byte = 32     Const TTR_val_min As Byte = 1 Private Sub TTR_control_enter()     Dim TTR_val As Byte     Dim TTR_val_old As Byte         T (Embedded)