Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / July 2003

Tip: Looking for answers? Try searching our database.

Inserting a checkbox makes Excel "Hang"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Mitchell - 18 Jul 2003 09:00 GMT
I am having a problem with inserting a checkbox into a
spreadsheet.
Using the controls toolbox I can insert a checkbox into a
blank worksheet and then link that checkbox to another
cell in the worksheet. The linked cell will then
display "TRUE" or "FALSE" depending on the status of the
checkbox. My problem is that when clicking the checkbox,
the computer will hang for a few seconds (up to 10) before
accepting the change.

I am currently running Excel 2000 on Windows 98 2nd
Edition on a Compaq P4 Evo computer.

What is unusal is that when performing the same task on a
Compaq P3 with the same configuration (Excel 2000 &
Windows 98) it works fine.

As I'm trying to develop a spreadsheet that uses mutliple
checkboxes & multiple dropdown boxes, this is very
frustrating. Could it be anything to do with missing
Service Packs?

Can anyone help?
Jan Karel Pieterse - 21 Jul 2003 08:11 GMT
Hi,

Maybe clearing out your WINDOWS\TEMP folder helps.

Controls on sheets cause Excel to add temporary files,
which are poorly cleaned up.

Regards,

Jan Karel Pieterse
Excel TA/MVP

>-----Original Message-----
>I am having a problem with inserting a checkbox into a
[quoted text clipped - 21 lines]
>Can anyone help?
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.