Ryan,

Look up Data Validation in Excel Help (not VBA Help) and in Google Groups
for more info. Data Validation is found in the Excel Data menu. Validation
applies directly to spreadsheet cells, no controls or programming required.
It enables you to specify a list of allowed entries in a given cell. You
can have unique validation for each cell or apply the same validation list
across several cells, rows, etc. The list can be specified in the Data
Validation dialog box or, probably better, you can specify a range on the
worksheet that contains your list. You can specify a range in another sheet
or workbook, but you have to use a named range (Insert - Name-Define).

From an earlier post I had assumed that the comboboxes you're trying to use
are from the Forms Toolbar. If you use the ones from the Control Toolbox,
you can use the Activate method. In order for it to be automatic, you'd use
a worksheet event, as Kevin discussed. Worksheet events are entered in the
worksheet code module in the VB Editor. To view the worksheet code module,
right-click the sheet tab and choose "View Code." In the dropdown box at
the top left of the code window choose "WorkSheet". In the dropdown box at
the top right, you will then see all the worksheet events, including the
SelectionChange event.

The following code is a SelectionChange event that you can paste into this
window. It will put the cursor in ComboBox1 (from the Control Toolbox) when
you tab to or click cell "L8": (I used ActiveCell instead of Target so it
won't fire if the user selects multiple cells that include L8.)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(ActiveCell, Range("L8")) Is Nothing Then
ComboBox1.Activate
End If

End Sub

hth,

Doug

"Ryan" wrote in message
...
Doug,

I just reread your data validation suggestion. I am not quite sure how to
accomplish this. If you could help me that would be great.

At this point, I have pretty much given up on having the comboboxes
automatically drop down. I just want to figure out a way to tab from a cell
into one. If I can accomplish that then I will be satisfied!

Ryan