Ryan,

I've spent some time the last couple days trying to figure something out for
you. I'm hardly an expert, but I've looked at all the methods and
properties for a dropdown box from the Forms toolbar and I can't figure out
how to tab into one. If you were using comboxes from the Controls toolbar
it seems to be as simple as "Combobox1.Activate." Maybe you should consider
switching? (I take it you can't use my earlier suggestion of using Data
Validation in worksheet cells).

Just wanted to let you know I've been trying...

Doug

"Ryan" wrote in message
...
I have an area on my spreadsheet where users input their data and then get
an output near the bottom of the page. I want to make the navigation of the
input part as easy as possible as there will be people who are not very
computer literate using this spreadsheet.

The problem that I am having is being able to tab into a combo box. I
found code from someone else that helps me tab through the form once I have
gotten inside a combo box, but I don't know how to get into the first combo
box. For instance, I have a combo box (combobox6) sitting on top of cell
D9. I want to be able to tab from cell L8 directly into the combo box.
Right now I tab from cell L8 to cell D9. Once inside of combobox6, I am
able to tab through the rest of the form the way that I want.

If anyone out there can help me find a way to tab into combobox6 from a
cell I would appreciate it.

Ryan