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: 17
Default Combo Box Data Validation - First Entry Blank

I've looked and read, but haven't found solution . . .

I'm using a combo box in a worksheet, not a user form. I've followed the
very helpful CONTEXTURES instructions, but when the combo box is selected at
double click in the cell, the combo box opens blank, and any value can be
entered without data validation error (what's typed is not in the list range
of valid values).

Validation for the cell alone works (if the combo box isn't used). The
combo box contains all the valid values and type-ahead works -- it's just
that when it opens, the blank space allows any entry and data validation
doesn't pick up on it if entered using the combo box.

Can I default to the first value (in a worksheet, not a form) and/or can I
make the free-form user entry error out? This falls under category of
"simple", "not easy" -- at least for a knuckle-draggin' non-technical
supervisor, . . . like me. Please advise.
 
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 Limits Data Entry The Merg Excel Worksheet Functions 1 December 13th 07 05:51 AM
Data Validation: stop blank entry Tetsuya Oguma Excel Discussion (Misc queries) 2 November 8th 06 02:27 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Combo Boxes for data entry moorefun Excel Worksheet Functions 1 February 3rd 06 09:03 PM
a data entry form with combo box xcao Excel Discussion (Misc queries) 4 June 25th 05 05:37 AM


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