LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Disabling the Combo Box

Good morning all,

I have a combo box in Sheet1 of my Excel file. What I like to do is to
disable the combo box so that when users click on it, nothing would happen
and selections would not display.

I would like to share a little background related to what I am looking for.
I have a code to perform a list of things on Sheet1 (and combo box is one of
those things). After a list of those things has performed, I want to disable
the combo box so that users can not revisit the combo box to make a selection
from it.

As part of my code, the code will check whether those things are performed.
If performed, the combox box will disable, and the users will receive a
message that since those things are performed, the combo box will not be
available.

Is it possible to disable the combo box? Could you help me with the code?

Thanks.
 
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
Combo box, select item, auto create another combo box in field Christine Excel Programming 2 October 8th 09 07:40 PM
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet questor Excel Programming 0 September 15th 08 01:38 AM
Excel VBA Combo Box Populating dependent on other combo box choices ikabodred Excel Programming 1 March 15th 06 03:16 PM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes DoctorG Excel Programming 3 February 23rd 06 12:15 PM
disabling the Files type combo box areddy Excel Discussion (Misc queries) 1 October 19th 05 02:37 PM


All times are GMT +1. The time now is 05:56 PM.

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"