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: 354
Default Lock cells for combo box values only

Hi,

I created an excel file where some of the cells are using "Validation" rules
that when the user selects the cell he can open a combobox that shows values
from a range declared earlier.

I want to limit the user to select only values from the list - currently he
can select from the list and write something else.

Also - how can I turn AutoComplete on these cells as well ?

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
Lock Axis Values? Ryan Charts and Charting in Excel 4 April 22nd 23 09:01 AM
How do I put combo box values into cells (without using @CHOOSE) LongTermNoob Excel Worksheet Functions 4 March 8th 07 01:44 PM
Combo box values based on other combo box value JCanyoneer Excel Programming 1 April 5th 05 06:41 PM
How do I lock a combo box's position once it is placed? tdore Excel Programming 1 January 14th 05 03:19 AM
registering the cell values of excel combo box associated values john_stevens Excel Programming 1 May 21st 04 09:39 PM


All times are GMT +1. The time now is 05:36 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"