ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Closing Excel user form generates error (https://www.excelbanter.com/excel-discussion-misc-queries/161626-closing-excel-user-form-generates-error.html)

Ken Warthen

Closing Excel user form generates error
 
I have a user form in Excel that creates an error when I close the form by
clicking on the X on the top right corner of the form. The form is used for
data entry and has a number of text and combo boxes on it. I also have a
status bar control (StatusBar1) that I use to prompt the user on the ENTER
events of the text and combo events. I clear the test in the EXIT events.
The error number generated is 380, invalid property value, and has a source
of SBarCtrl.

Has anyone had a similar experience and knows what I'm doing wrong here?
This is an Excel 2007 application.

TIA

Ken Warthen



All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com