I have a really handy Workbook, created by a former coworker, that I
have worked with for a long time and which was, in fact, originally
what I used to teach myself about Excel. It uses what look like
ComboBoxes to select the names of employees whose information is then
displayed elsewhere on the Worksheet.

Now I've never been able to figure out what these "ComboBoxes" really
are. As I said, they look like ComboBoxes, but when I right-click on
them "View Code" and "Properties" are not options on the pop-up menus.
And when I open the "Properties" window and then click on them, what I
see is the "Properties" window for the sheet on which they are located.
Finally, when I open the "Format Control" window, there is a tab named
"Control" present that is not there for actual ComboBoxes.

Any clue what these things are or how to create them without having to
Copy and Paste from that workbook???

Thanks for your help! - Pikus


---
Message posted from http://www.ExcelForum.com/

pikus,

They look like ComboBoxes, work "like" ComboBoxes but aren't
really ComboBoxes????

Maybe DataValidation??

Take a look he
http://www.contextures.com/xlDataVal01.html

John

"pikus" wrote in message
...
I have a really handy Workbook, created by a former coworker, that I
have worked with for a long time and which was, in fact, originally
what I used to teach myself about Excel. It uses what look like
ComboBoxes to select the names of employees whose information is then
displayed elsewhere on the Worksheet.

Now I've never been able to figure out what these "ComboBoxes" really
are. As I said, they look like ComboBoxes, but when I right-click on
them "View Code" and "Properties" are not options on the pop-up menus.
And when I open the "Properties" window and then click on them, what I
see is the "Properties" window for the sheet on which they are located.
Finally, when I open the "Format Control" window, there is a tab named
"Control" present that is not there for actual ComboBoxes.

Any clue what these things are or how to create them without having to
Copy and Paste from that workbook???

Thanks for your help! - Pikus


---
Message posted from http://www.ExcelForum.com/

Sounds like an Excel Form Control.

From Excel's menu: View | Toolbars | Forms
You create them using this toolbar.


"pikus" wrote in message
...
I have a really handy Workbook, created by a former coworker, that I
have worked with for a long time and which was, in fact, originally
what I used to teach myself about Excel. It uses what look like
ComboBoxes to select the names of employees whose information is then
displayed elsewhere on the Worksheet.

Now I've never been able to figure out what these "ComboBoxes" really
are. As I said, they look like ComboBoxes, but when I right-click on
them "View Code" and "Properties" are not options on the pop-up menus.
And when I open the "Properties" window and then click on them, what I
see is the "Properties" window for the sheet on which they are located.
Finally, when I open the "Format Control" window, there is a tab named
"Control" present that is not there for actual ComboBoxes.

Any clue what these things are or how to create them without having to
Copy and Paste from that workbook???

Thanks for your help! - Pikus


---
Message posted from http://www.ExcelForum.com/

Well thanks, but I didn't see any examples of the particular objects I'
speaking about, though they are used in much the same way that is bein
discussed. - Pikus

And it is just as wierd as it sounds..

--
Message posted from http://www.ExcelForum.com

YES!!! Thank you Rob van Gelder!!! I've been sitting on that for SO
LONG! Thank you thank you thank you!

- Pikus:D


---
Message posted from http://www.ExcelForum.com/