Set the ShowModal property of the form to True.

Instead of using the combo box fromt the control toolbox, try to use the combo
box from the forms toolbar. That will prevent anyone from writing in the drop
down list.

Instead of using the combo box fromt the control toolbox, try to use the combo
box from the forms toolbar. That will prevent anyone from writing in the drop
down list.

Or in the properties set MatchEntry to 2 - fmMatchEntryNone
I just tried it and it works.

Setting frmMatchEntry to 2 still allows the user  to type  in the drop
down list.

I am unable to find the the Forms Toolbar in the VBE. I am aware it
exists in the worksheet. My requirement is to have the combo box on
a user form in the VBE.

This is an option in the properties window which (I beleive says) Limit To List
... check Yes or True and they can only select  what you have in the list.

in the Properties Window select  "MatchRequired = True"

Even if you set match required = true, I found that in the combo
box, you are still able to type  in a value that is not in the list.
Yes admittedly it will throw up an error, but I would like the
situation such that the user  is only able to select  from the list
and nothing else.

>I appreciate all the suggestions and help the various users have offered
but I seem to conclude that it may not be
>possible for a combo box to function like a calendar control (i.e. quite
simply, for the user  to click on the down
> arrow and select  from the list). I am aware this can be done quite easily
in ACCESS by using the LimitToList >
>property of the combo box). If any one has a simple solution that works
exactly like the combo box in
>ACCESS, it would be welcomed.

Just a minute... Don't give up yet.

I believe that using "MatchRequired" in Excel is the same as the way an
ACCESS combo box works with "LimitToList".

> Even if you set match required = true, I found that in the
> combo box, you are still able to type  in a value that is not
> in the list.
> Yes admittedly it will throw up an error, but I would like
> the situation such that the user is only able to select from
> the list  and nothing else.

Using LimittoList in Access also allows you to type in entries not in the
list.

What *exactly* have you seen as a difference when you do what Moses???

My apologies, I read that LimitToList = yes restricts the user  to
selecting only from the drop  down list. After your message, I have
just tried the combo box in ACCESS and you are right that it
functions the same as MatchRequired = True.

I am now asking how does one get the combo box to function like a
drop down list  such that the user is completely restricted to make a
selection only from the drop down list.

The best bet for you would be to put a text box which is disabled. Put a
button which has an image to look like the button from the combobox to the
right of the text box. Then on top of the text box put a list  box which has
visible=false. When the arrow is clicked make the list box visible=true then
when the selection is made in the list box make the text box value = the list
box selection.value and make the text box visible=false

A couple of points. Where can I find a button that looks like a
combo box button and secondly, in the last line of your suggested
solution, you say make the text box visible=false. Do you mean that
the list  box visible = false?

To get the image you could do a screen copy and paste into paint, then cut the
relevant square to a file. You would then use that file for the image
property of the command button.

And. Yes! I apologise. I did mean make the list  box disappear.

I hope this all helps.

You could always try putting code behind the change event for the combo box.
The code would check through the drop  down list  for similar text. As there
are only 31 entries max for drop down list the overhead would be negligable.

This should do the trick I think...


Private Sub cboLimitToList_Change()

Dim slText As String
Dim ilN As Integer
Dim ilLen As Integer

If cboLimitToList.Text = "" Then
Exit Sub
End If

slText = cboLimitToList.Text
ilLen = Len(slText)

For ilN = 0 To cboLimitToList.ListCount - 1
If slText = Mid(cboLimitToList.List(ilN), 1, ilLen) Then
Exit Sub
End If
Next

cboLimitToList.Text = ""

End Sub

I appreciate all the suggestions and help the various users have
offered but I seem to conclude that it may not be possible for a combo
box to function like a calendar control (i.e. quite simply, for the
user to click on the down arrow and select  from the list). I am aware
this can be done quite easily in ACCESS by using the LimitToList
property of the combo box). If any one has a simple solution that
works exactly like the combo box in ACCESS, it would be welcomed.

In 2003 it's View / Toolbox in the VBE to get the toolbox.