In requirement module one of the field should allow only R/A or SER-123 or SER-1234. (here nos 123 and 1234 will change for each time)It should not allow any other values. Create a global variable to store the current value. DIM g_save_value ===================================================== Sub ...