I have a userform with a textbox that is formatted as time. A spinbutton sets the textbox's value by combining the textbox's tag property with the spinbutton's value, and the textbox then works fine displaying different time values from a column of data in a worksheet via changes in the spinbutton. However once I add code to the spinbutton''s change event that sets the textbox's contolsource property, the textbox starts displaying the time as a decimal instead of a time. I have tried multiple syntax options for formatting the textbox as a time after the controlsource statement, but none seems able to affect it at all. (I need the spinbutton to set the textbox's controlsource property so that the textbox can also feed the worksheet, not just vice versa.) Hope that description makes sense. Has anyone else encountered this? I hope I'm not repeating a previous thread; I searched Google for several hours today before deciding to go ahead with making an account here and posting the question. Would definitely appreciate any insight from you gurus. Many thanks!