Software

Ask something
Discussion Locked

Combo boxes within Excel

0 helpful
1 reply

by michaelm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I come from a software company that is totally against the use of MS Access & I'm trying to create a s/sheet (that would be sooo much easier in Access) that logs all of our support calls.

We have a massive number of codes to identify the various parts of our software application & rather than have my users freeform type in fields, I'd much rather they have to select from a drop down list.

So far I've set-up validations to do this & it's OK, but it does not provide the additional functionality that a combo box does with the ability to type a couple letters in & search based on that.

If someone could assist me with this it would be greatly appreciated.

Regards,

Michael

1 reply

by dklippert

teve Bullen has what you want:

http://tinyurl.com/qtke

Scroll down to the VBA Programming section to download a working sample of ComboBox.zip

"The standard linked edit-list box in Excel is annoying in that the selection in the list box does not reflect what is typed in the edit box. This file uses standard VBA code to simulate a linked edit-list box similar to the combo box in MS Access and the standard Help Index screen."

This discussion is closed to new replies.