Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Active x control

Hi.

I have a combo box with active x control, however users are able to delete. Users are able to delete field from the combo box but I would like to know if there is somewhere in the properties where I can not allow the users to delete and alway default to one of the combo box options.

If possible without Vba coding.

Thanks so much

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Active x control

Hi.

I have a combo box with active x control, however users are able to
delete. Users are able to delete field from the combo box but I
would like to know if there is somewhere in the properties where I
can not allow the users to delete and alway default to one of the
combo box options.

If possible without Vba coding.

Thanks so much


Have you tried using a Data Validation dropdown list?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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
Form Control versus Active Control? When to use which? LightLY Excel Programming 2 December 6th 11 06:17 PM
How to use active X Control Aligahk06 Excel Programming 3 November 3rd 09 05:55 PM
ACTIVE X CONTROL? Jase Excel Discussion (Misc queries) 1 May 9th 08 12:49 AM
Difference between a Forms Control verus Active-X Control funGT350 Excel Discussion (Misc queries) 6 May 6th 08 11:20 PM
Tool Tip Text for Form control/ Active-X control Freddie[_2_] Excel Programming 0 October 19th 04 04:14 AM


All times are GMT +1. The time now is 08:23 AM.

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

About Us

"It's about Microsoft Excel"