Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error while opening/Closing excel Hari Excel Discussion (Misc queries) 0 November 17th 06 06:55 AM
cutting and pasting rows from one sheet to another generates error JT Spitz Excel Discussion (Misc queries) 7 February 14th 06 07:06 PM
Error report closing excel Maz Excel Discussion (Misc queries) 0 September 30th 05 11:26 PM
User Form Error theguz Excel Discussion (Misc queries) 3 August 15th 05 10:49 PM
Excel Analysis Add-in EOMONTH generates #NAME? error Ray Excel Worksheet Functions 6 July 18th 05 07:00 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"