This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

我告诉你!

1patrick(不停游的鱼)

1.select the cell where you want a list.
2.select menu: Data>Validation
3.under Settings Panel:
- Under Allow: select List;
- Under Sources: select the field where you put your list content. or select the icon in the right side of sources box: for example, if you want the listbox contains a, b, c, d, e... you can put a b c d e in cells H2, H3, H4, H5, H6. The in sources you put in =$H$2:$H$6 or select the icon to pick the fields by mouse.

Usually, those list content are put in columns far far away, such as colume Z or AA, so you won't see it. And you can shrink the column width to make them sort of disappeared.

If you still have problem, send me your phone, I will let you know.
Have fun.

(#225909@0)
Last Updated: 2001-10-15
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

枫下沙龙 / 谈天说地 / 请问各位DX一个问题。想在WORK或EXCEL 加入一个下拉是菜单选项（COMBO BOX），想知道里面的东西是怎么”放“进去的？ -kevinxin(Kevinxin); 2001-10-15 {102} (#225793@0)
就象本论坛顶部的“选择模块”，你一按箭头，会出来如：枫下家园，枫下沙龙等。这枫下家园等是怎么放进去的？

给我上来！ -kevinxin(Kevinxin); 2001-10-15 (#225808@0)

再上！真累啊。 -kevinxin(Kevinxin); 2001-10-15 (#225819@0)
我告诉你! -1patrick(不停游的鱼); 2001-10-15 {719} (#225909@0)
1.select the cell where you want a list.
2.select menu: Data>Validation
3.under Settings Panel:
- Under Allow: select List;
- Under Sources: select the field where you put your list content. or select the icon in the right side of sources box: for example, if you want the listbox contains a, b, c, d, e... you can put a b c d e in cells H2, H3, H4, H5, H6. The in sources you put in =$H$2:$H$6 or select the icon to pick the fields by mouse.

Usually, those list content are put in columns far far away, such as colume Z or AA, so you won't see it. And you can shrink the column width to make them sort of disappeared.

If you still have problem, send me your phone, I will let you know.
Have fun.

谢谢你。你讲的这个也挺好玩。不过我问的是另外的一种，请参看下面那为DX说的。我现在不知道怎么把A，B，C，D等放进COMBO BOX里？ANYWAY 多谢了。 -kevinxin(Kevinxin); 2001-10-16 (#226724@0)

I don't know. -tuxue(吐血); 2001-10-15 (#225818@0)

多谢帮忙！ -kevinxin(Kevinxin); 2001-10-15 (#225825@0)

I don't know either. -macsym(日进斗斤); 2001-10-15 (#225847@0)
I don't know again. -tuxue(吐血); 2001-10-15 (#225859@0)
简单说一说，不知道你是否问的是这个。 -rockywei(rocky); 2001-10-15 {704} (#225895@0)
　　首先，将鼠标移到菜单那一条上击右键，选择出现下拉菜单中的“自定义”，会出现一个“自定义”框，选择“类别”的最下面一项“新菜单”，然后用鼠标按住右面“命令”框里的“新菜单”，可以把它直接抓到WORD菜单那一行中，此时菜单上除了“文件”、“编辑”、“视图”等等之后会出现一个“新菜单”字样，此时在“自定义”框不关的情况下（切记），将鼠标指向你已经建成的“新菜单”上，击右键，在重命名一栏中给它起个名字。这样一个新COMBO BOX就建成了。
　　接下来在“自定义”中选择相应的类别，每个类别都包括很多的命令，这些命令在右面的“命令”栏中出现，选择你想添加的命令，象刚刚装新菜单一样抓到你的那个新建的菜单中，（用过windows98往开始菜单中加命令吗？方法是一样的。）所有的命令都可以加进去的。
　　罗嗦了点，希望说得明白。:)

谢谢。但是问题是知道怎么CREATE一个COMBO BOX，不知道怎么不那些可以选择的内容放进去。在那些属性里面找不到啊。 -kevinxin(Kevinxin); 2001-10-16 (#226719@0)

@Florida

我告诉你!

Replies, comments and Discussions:

More Topics