Positioning drop down box over listbox entry

P

PatrickS

I have a 2 column list box on an Excel form. I'd like the user to be able to
set any value in the second column to a value in a predefined list.

What I'm aiming to do is this: when the user clicks on an item in the list
box a combo box is positioned over the item in the second column and
displayed. When an item in the combo box is selected the value in the second
column is set to whatever has been selected in the combo box and then the
combo box is hidden.

I have an idea on most of what I need to do, however I'm a little stuck on
how to position the combo box in the correct position each time. I'd also
prefer to avoid using anything other than the standard controls in Excel, and
don't have the option of using any .NET stuff.

Any suggestions would be appreciated.
 
P

PatrickS

I've found a way of doing what I want to do using TopIndex, ListIndex and a
drop down within a frame control, however it would be nice if I could
increase the row height in the listbox slightly to accomodate the combo box,
as this is slightly higher than an individual row in the list box.

Any ideas on how to achieve this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
Possible to Combine reports to's to a single box? 0
Combo or list box 0
Creating a Search using a combo box and then creating a report. 4
Highlight multiple items in listbox based on textbox item 1

Top