View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NooK NooK is offline
external usenet poster
 
Posts: 1
Default Non-Editable ComboBox?

I am quite new to VBA and I am writing a program which have a couple of
ComboBoxes and those comboBoxes are not to be editable.

I have looked everywhere on the net and couldn't find it.

How can I make them not editable so the user can only choose the
choices in the box and not be able to write anything in it?

I tried setting Locked property to True but then I can't select
anything (When I click on the arrow down it doesn't do anything).

Hope someone can help me.

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/