Closing Excel user form generates error

K

Ken Warthen

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to remove error from conflicting code 0
Add additional information to excel form after original data entry 0
Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Crating User Form to Add Names 1
Generated text copies into another template 0
Excel does not accept text format! 0
Creating a Search using a combo box and then creating a report. 4

Top