I have a Visual Basic macro for Excel that incorporates Userforms to input responses to a series of questions. In Excel 2000 clicking on a control button transfers the responses to a spreadsheet then updates the displayed information from another sheet, however in Excel 95 and earlier versions the information displayed will not update until the close button is clicked.
