How to create a "combination drop-down edit" box?

R

Rocko

I want to create a combination drop-down edit box in my
SS, but the icon for this object is grayed out on my
control bar. I use the drop-down box icon, but cannot use
this icon. Any help on this?

Thanks!
 
T

Tom Ogilvy

create a dialogsheet. Put one on the dialog sheet. Copy it.

Paste it on a worksheet.

However, usually when a control is not available, there is a reason, so you
might run into problems with it on the worksheet. I haven't used one enough
to say. But it seems the above method was what I used to get it on a
worksheet.
 
R

Rocko

Since I am using Excel 2000 and dialog sheets apparently
are from a previous version (5.0?), how do you create a
dialog sheet in Excel 2000?
 

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

Extracting value from Combination drop down-edit box 2
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
Macros using drop downs 3
Help with creating drop down 1
pull down menus in spread sheet 1
EXCEL DROP DOWN 2
Cell Referencing too and from check boxes? 0
Drop Down Box 7

Top