查看: 3589|回复: 1|
在线时间0 小时经验2 威望0 性别男最后登录注册时间阅读权限20UID549041积分52帖子精华0分享0
EH初级, 积分 52, 距离下一级还需 298 积分
积分排行3000+帖子精华0微积分0
各位大侠：
& & 小弟请教个问题，盼能尽快解决，现在我用的OFFICE版本为2007版，但原来在03版使用的“窗体”单元格在07版“开发工具栏”中打开后在“设置控件格式”中没有“控制“那一项，该如何调出啊，望尽快回复，谢谢！
在线时间300 小时经验366 威望0 性别女最后登录注册时间阅读权限30UID1248340积分366帖子精华0分享0
EH中级, 积分 366, 距离下一级还需 734 积分
积分排行3223帖子精华0微积分0
回复 1楼 hekun1215 的帖子
开始，Office选项，自定义，常用工具栏，开发工具，控件
关注我们，与您相约微信公众平台！
Copyright 1999 - 2017 Excel Home. All Rights Reserved.本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！
Powered by
本站特聘法律顾问：徐怀玉律师 李志群律师 &&查看: 4500|回复: 3|
在线时间54 小时经验89 威望0 最后登录注册时间阅读权限20UID1960290积分89帖子精华0分享0
EH初级, 积分 89, 距离下一级还需 261 积分
积分排行3000+帖子精华0微积分0
如图所示，插入一个控件，要对其值进行设置，右键点击进入“设置控件格式”，却发现没有“控制”选项，只有“大小”“保护”“属性”“可选文字”四个选项，请问该怎么解决
22:14 上传
在线时间1530 小时经验1214 威望0 性别男最后登录注册时间阅读权限50UID169278积分1264帖子精华0分享0
EH高级, 积分 1264, 距离下一级还需 736 积分
积分排行848帖子精华0微积分0
窗体和控件工具不太一样，你可以点击查看代码进入SpinButton属性 设置，如下图（我用的2003版
22:50 上传
在线时间54 小时经验89 威望0 最后登录注册时间阅读权限20UID1960290积分89帖子精华0分享0
EH初级, 积分 89, 距离下一级还需 261 积分
积分排行3000+帖子精华0微积分0
jpowe 发表于
窗体和控件工具不太一样，你可以点击查看代码进入SpinButton属性 设置，如下图（我用的2003版
你这方法不管用，我已经明白是怎么回事了，应该插入表单控件，而不是Active控件，不过还是谢谢你
在线时间52 小时经验58 威望0 性别保密最后登录注册时间阅读权限20UID2609373积分58帖子精华0分享0
EH初级, 积分 58, 距离下一级还需 292 积分
积分排行3000+帖子精华0微积分0
我也想学习控件格式制作
关注我们，与您相约微信公众平台！
Copyright 1999 - 2017 Excel Home. All Rights Reserved.本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！
Powered by
本站特聘法律顾问：徐怀玉律师 李志群律师 &&您现在的位置： &
Excel2010中使用下拉列表控制显示不同系列的图表
Excel2010中使用下拉列表控制显示不同系列的图表
　　当Excel图表数据中包含多个系列时，通常需要让这些系列同时显示在图表中进行对比。但有时可能无需让各系列同时显示在图表中，这时可以添加一个下拉列表来选择某个系列，让该系列单独显示在图表中以便查看。
　　假如下表为某公司全年的销售数据，这些数据位于A1:D13区域，需要通过下拉列表选择某个产品系列，让所选系列单独显示在图表中。
　　在工作表中添加并设置组合框控件
　　1、可以通过多种方法在工作表中添加下拉列表，如通过数据有效性、添加ActiveX 控件、添加表单控件等。本例以添加表单控件为例，在功能区中选择&开发工具&选项卡，在&控件&组中单击&插入&表单控件&组合框(窗体控件)&。
　　2、如果&开发工具&选项卡没有显示在功能区中，可在&选项&对话框中进行设置让其显示出来，具体参考本站其他文章。
　　3、这时鼠标指针变成细十字形，按住鼠标左键在工作表中拖动，绘制一个组合框控件。由于在单击该控件时，需要在组合框的下拉列表中显示&产品A&、&产品B&等系列名称以供选择，因而在设置前需先将这些系列名称输入或粘贴到某列中，本例将B1:D1区域中的系列名称通过&选择性粘贴&转置&粘贴到I1:I3区域。
　　4、右击组合框控件，在弹出的快捷菜单中选择&设置控件格式&，弹出&设置对象格式&对话框，选择&控制&选项卡，将&数据源区域&设置为&$I$1:$I$3&，将&单元格链接&设置为J1单元格，这样在组合框中选择某个系列名称时，J1单元格中就会显示相应的数字。
　　添加辅助列并设置公式
　　以F列和G列为辅助列。将A1:A13区域中的&月份&数据复制到F列，在G1单元格中输入公式：
　　=OFFSET($A$1,ROW(A1)-1,$J$1)
　　然后拖动填充柄，填充公式到G13单元格，在组合框中选择某个系列，如&产品A&，G列就会显示该系列的数据，如图所示。
　　插入图表
　　选择F1:G13区域中的某个单元格，在功能区中选择&插入&折线图&折线图&，插入图表。在组合框中选择某个系列，图表就会显示该系列。
&&&主编推荐
&&&热门试卷
&&&最新视频
&&&热门阅读
&&&最新问答
&&&&&&&&&&&&&&&
希赛网 版权所有 & &&&&湘教QS2-164&&增值电信业务经营许可证湘B2-?é?? Search &
°??à±????? Browse by Category
..... ?? 3/4 ???
.......... Access
.......... Microsoft SQL Server
.......... Oracle
..... ???? 1/4
.......... ?·??AE÷
.......... VPN
..........
1/2 >>>>>>>>ú
..... JAVA????·???AE÷
.......... WebLogic
.......... Websphere
..... ?? 1/4 ?/?? 1/4 ?
.......... Lotus Domino
.......... Lotus Notes
.......... Microsoft Exchange
.......... Microsoft Outlook
..... ?? 1/4 ?
.......... ?¨? 1/2 >>ú
.......... ±? 1/4 ?± 3/4
.......... ?ò??>>ú
.......... ?ae???è±,
.......... ·???AE÷
............... ??Windows Server 2003 ????·??????í?? 1/4 ? 1/4 ??????í?ó
..... AE???
..... °ì?<<?í 1/4 ?
.......... Excel
.......... Powerpoint
.......... Project
.......... Visio
.......... Word
..... ??×÷?u??
.......... AIX
.......... Microsoft Windows 98/ME/2K/XP
.......... Microsoft Windows Server
.......... Solaris
.......... Unix/Linux
..... ??? 3/4 °??<<
..... ·??????í
..... ?¤ 3/4 ss?í 1/4 ?
.......... ×??ae?í 1/4 ?
..... ?¤×÷??u?
..... ?u?¨ 1/4
.: EXCEL??u??ê
EXCEL??u??ê
?? 1/2 é???§?°VBA?(R)?°????,?>>¨ 1/4 ,·???? 1/4 ?AE?>>,??ê?? ?????????°?ê?±???,?>>?u??EXCEL???>>????u?VBA?? 3/4 ??? ???? 1/2 <>??,?±?u???,????<<?????ê??????? 1/2 ?è?? 1)?ò?????¤×÷? 3/4 ???·??AE????¤×÷? 3/4 ?? 3/4 -??±??? 2)????A1u???,???u÷???°?????±?¤ 3/4 ss?,?? 3)?????°?¤ 3/4 ss?±???°?ê?±???°? 1/4 ?AE???ê?±?? 4)?????°,?±????<<?±×÷???ê???ae>>>>?????ê????u?>>÷?·?¨,×????????±×????,????? 3/4 ?°? 1/4 ?AE?±????±????°????? 1/4 ?AE?±?¤ 3/4 ss?,????? 3/4 ???????ae>>>>?????ê???÷????±???·?±????(C)?ê?? ??&?ê??×??à????255,?×?·???????±?????×??,??? 1/4 ??AE???????u?×?·?°ü?¨??×??,????×?????>>(R)?ss???ê?????>>???í??????,????¨??????>>(R)?ss?ú±í??,??? 5)?????°,?? 1/2 ?±u??°u???,??±???????°? 1/4 °,?±??????u??ì?<<,u?>>÷?°?·?¨?±?? 6)u?>>÷?°????? 1/4 ?AE?±?¤ 3/4 ss?,°????? 1/2 á???ê? 1/4 ?AE?????? ?ù&?????°????? 1/4 ?AE?±?¤ 3/4 ss?,??? 1/4 ?????????????????°?¤ 3/4 ss?±???°?ê?±???°????? 1/4 ?AE?±?? ? 1/4 ?AE?ê?>>,??ê?ó 3/4 ??????????ü???? 1.4 ?????ê u±?????>>,??ê?±??EXCEL°????ê?? 3/4 ?????u??é?? 3/4 ???VBA?ú??????EXCEL 1/2 ????°?????±??u<<VBAu??°?????±?>> 1/2 ???????×÷±?u? 1/4 ò±???>>???????>>?u??>>?(C)????EXCEL±ê× 1/4 ?ü???ù??·¨?u??u??????????????>>u(C)?ì?¤??EXCELu??°?????±????? 1/4 >>áAEae??×? 1/4 ????>>?????(C)?°?????±u??é??????u 1/2 u×??????° 3/4 ????u?????????,???? 1/4 ?AEu??ê??????°?????? 1/2 ?è 1/2 ????? 1?(C)?????????>>,?u???,???±???A3?? 2?(C)?????°?¤ 3/4 ss?±???°?ê?±???°?ê?±????? 3/4 ?°?ê?±??>>°?ò?? 3?(C)?????°,?±????<<?±???????°?????±???òA3u???,?u????<<±????ì?<>?ó???????ê????±? 1/4 ??????ó?? 1.5 ?é??? 1/4 ?AEu??ú?? u 1/2 u×???????????AEEXCELu?????????????????(C)??>>ó.??,??????????VBAu??? 3/4 ?°?. 1?(C)?????°?¤ 3/4 ss?±???°?ê?±???°?ê?±????? 3/4 ?°?ê?±??>>°?ò?? 2?(C)u?>>÷??±í??u??°,?±????<<?±,?????°±à 1/4 -?±°????? ???±??>>á?ò??VBAu?±à 1/4 -AE÷?°???¨VBE?(C)??????,?±à 1/4 -AE÷?????ó???ê?,?u?÷???? 1/2 <>á???>>???(C) Sub ,?±????<<() '' ,?±????<< Macro ' xw
1/4 ?? 1/4 u??ê '&' With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End Sub
1/2 <>á?(R)·??ì?¤?????ú???????>>?????ü???????????>>??AEae??u????????§?°VBA>>ò±à??????????????????±? 1/2 ??????§?°?>>???????? Sub ,?±????<<():?????êu????AE?? ?? 1/4 ?u????° '?±???·u??????AE???°×????±???ü??? 1/4 ?AE?ê?±×????ú?ú?? ??With ???·u 1/2 End With
1/2 á??u? 1/2 á????With 1/2 á???? 3/4 ????????? 3/4 ????êu??÷????·???×???u????°selection?±???ü?ú±í?°?>>????? 3/4 u????ò?±?¨ 1/4 ??????¨???ò?(C)??With Selection.Interior ???ü??×÷?°???????òu?u??????±.???????? 3/4 ??è??,????ò????u??>>?(C)?°?????±?? AE????? .ColorIndex = 3:
1/2 <<,??????è???ì?<>????u????üu?×÷?????? 1/4 ò>>??? 3/4 ???????u??ú?ae??????With?óu???,?ü??With 1/2 á??u??>>??·????í?????ì?<>??×?>>???3.(?ì?<< 3/4 ? 1/2 ???·????AE×÷??3?? 3/4 ? 1/2 ???à???)?????¤u?>>°???? 1/2 <<3,???AE?????×????????? .Pattern = xlSolid???è??,????òu?????? 1/4 °,????????? 1/4 ?AE?ê???ù???????>>???????è?????>>?????ê???>> 1/2 <<AE? 1/4 ?? 1/4 ????(?ò?????°? 1/4 °,?±???????????>>?????>>?????????è???????(C)??xlSolid±í? 3/4 ???<<?? .PatternColorIndex = xlAutomatic??±í? 3/4 ????? 1/4 °,u×?AE???<<??×??????<<?? End With: 1/2 á??With ?? 3/4 ??? End Sub:??,??êu? 1/2 á???? 1.6 ±à 1/4 -? 1/4 ?AEu??ú?? ?????>> 1/2 ???????? 1/4 ?AE???>>,??ê???é?????ú?????ú??????? 1/2
3/4 ??u 1/4 ??????>>AE?×÷??????? 1/2
3/4 ????????????ê??×÷?>>,???,???? 3/4 ???à?à?????±u 1/2 ?????ae?ú???à???? Sub ,?±????<<() ' ,?±????<< Macro ' xw
1/4 ?? 1/4 u??ê
With Selection.Interior .ColorIndex = 3 End With End Sub ?ê???ó?????¤×÷±í?????é?>>??????>>á·??? 1/2 á??????,??°u?×????>>?ù????With ?? 3/4 ??° 1/4 ????>>??: Range(&A5&).Select ??×?????,??ê,?ò??????? 1/4 ??????,?u???,?,?ê???? 1/2 á??? 1/4 ????A5u???,?±??ì. ??????????u 1/2 ??±à 1/4 -? 1/4 ?AEu??ê???ù·??? 1/4 òu????è??±à 1/4 -?ê???ò????????,?· 1/2 ?aeu??-?ò???>>????? 1/4 ?AE?????í???>>u??>>??,???????? 1/4 ?AEu??ê?????à?àu??? 3/4 ??è??? 3/4 ?????á,ss?êu????????????????????? 1/4 ??êu???????±????? 1/4 ???????>>ò?->>·u???·¨? 1/4 ?AEu??? 3/4 ??? 1.7 ? 1/4 ?AE?êu? 3/4 ????? ????×???>>?u??í?àEXCEL?????ó?à? 1/4 ??????? 1/4 ?AE?ê???ê??.u<<???ê 1/4 ?? 1/4 AE÷?ae?????? 3/4 ?????.?¨???ê 1/4 ?? 1/4 AE÷??·¨?ê??u??¤×÷??: 1)? 1/4 ?AEu??ê??????>>ò?->>·????. 2)??>>ú 1/2 >>>>???????, 1/4 ???>>§??·¨ 1/2 ???????, 1/4 AE??>>ú??·¨,????á? 3/4 . 3)??·¨??? 3/4 EXCEL??>>°?ò. 4)??·¨??? 3/4 ×??¨???°??. 1.8 ?? 1/2 á ± 3/4 ????,???? 3/4 -?AE????VBAu??>>?(C)>>ù??????,??>>á? 1/4 ?AE?ê??±à 1/4 -?ê?????? 1/2 ???? 1/4 ?AE?êu? 3/4 ?????.????????.?????? 3/4 -?? 1/2 <<???§?°VBA????VBu?±à???????ò????>>ù??.?? 1/4 ü?????? 3/4 -?? 1/2 ????>>,???u×, 3/4 ????u,???? 1/2 ?????????±à??.???ae???(C)???·?°,×??ê?ó?????????ae??. ? 1/4 ? 1/4 : 1)VBA?>>??????EXCEL??? 2)VBA??>>ù??????????? 3)?u?uEXCEL??VBAu????u. 4)???????????ê? u?????&???í? 1/4 ?AEu??ê2.1 ???ê?,?¨?ì 1/2 ? 1/4 ü ?????í?????? 3/4 -??????u??ê?,?¨?ì 1/2 ? 1/4 ü???ì 1/2 ? 1/4 ü???, 1/4 üu?×é????u±AE?°????±?????>>???ü??????????CTRL+C ???í?à???ò???ú±í?°,??AE?±?ü????u±,??ê?,?¨???ì 1/2 ? 1/4 ü?ó?? 3/4 ????????ì 1/2 ? 1/4 ü???????ê?????>>±??¨???°?¤ 3/4 ss?±??u??? ×?????u±°ü???êu??¤×÷? 3/4 ?ò???± 1/4 ??????ê?,?¨?ì 1/2 ? 1/4 ü>>á,?,?EXCEL????u??ì 1/2 ? 1/4 ü????????°?CTRL+C?,?¨,???,??ê??????CTRL+C 3/4 ??>>??????,??AE?ü??????????· 1/2 ·¨?????ò????EXCELu??ì 1/2 ? 1/4 ü??u??¨??A4? 1/2 ?ò??????24???(R)?à?(C)?? 1?(C)?ò??EXCEL°??ú?? 1/4 ????????°??? 1/4 ?±?????? 2?(C)???°?????ì 1/2 ? 1/4 ü?±?? 1/4 ? 1/4 ????????°?±?ì 1/2 ? 1/4 ü?°±ê???? 3?(C)??>>÷,?±ê???????ì 1/2 ???u????????°?ò???±?? 4?(C)?????°?ò???ù??±ê?????ù??×??÷???±??u?>>÷?°?·?¨?±?? ???????? 1/2 ¨?ê?±?,?¨?ì 1/2 ? 1/4 ü???????????? 1/2 ¨?ó???,?¨???????? 1/2 ¨?¨? 1/4 ?AE?(C)?ê?±?,?¨?ì 1/2 ? 1/4 ü???>>????? 1/4 ?AE?ê?±???????ê???ó?????°?ì 1/2 ? 1/4 ü?±??± 3/4 ?ò???????à??u? 1/4 ü??? 1/4 ?AE?ê?ó?,?¨?ì 1/2 ? 1/4 ü???? 1/4 òu????>>?è?????°?¤ 3/4 ss?±?°?ê?±????? 3/4 ?°?ê?±??>>°?ò?????????,?¨?ì 1/2 ? 1/4 üu??ê????u?>>÷?°?????±°??????¨???°?????±??>>°?ò 1/2 ????è???? 2.2
3/4 ??¨?ê±??aeu??>>?? ?ê??±??ae??????????u??>>???? 1?(C)u±?°?¤×÷? 3/4 ???¨?>>??,??¤×÷? 3/4 ?ò???±??,??ê?????????(C) 2?(C)???¤×÷? 3/4 ?? 3?(C),????ê?¤×÷? 3/4 ?? 2.3 ,????ê?¤×÷? 3/4
,????ê?¤×÷? 3/4 ???????ê???è 1/4 AEu??>>??????u? 3/4 ss??×???????????u??¤×÷? 3/4 ??u??>>?? 1/2 <>á?? 1/2 ¨?????°PERSONAL.XLS&u????? 1/4 ???????,??? 1/4 ??ae?????ò??u±EXCELAE????±>>á×??? 1/2 <>????¤×÷? 3/4 ?ó?ae?¨???°?°???±??u????????°?????????±?ó????????· 1/2 ±?u?·????üu??ae?????(C)????????????,??ê???à,??¤×÷? 3/4 ? 1/4 ???????????? 3/4 ???u±?? 1/2 ¨,????ê?¤×÷? 3/4 ???? 1/2 <<?ê±??ae??AE?????,????ê?¤×÷? 3/4 ±??ae???°XLSTART?±?? 1/4 ? 1/4 ????? 3/4 ss???· 3/4 ?????C:\WINDOWS\Profiles\Application Data\Microsoft\Excel\XLSTART????????u????°XLSTART?±?é???? ×??????????ae??,????ê?¤×÷? 3/4 ???ò??u±EXCELAE????±>>á×??? 1/2 <<???? 1/4 ??ò???????????ò???ü?ae·???XLSTART?? 1/4 ? 1/4 ????? 2.3.1 ±??ae?êu 1/2 ,????ê?¤×÷? 3/4
± 3/4 ?·?°, 1/2 <>,? 1/4 òu?u??êu 1/2 ,????ê?¤×÷? 3/4 ,,??ê????± 3/4
1/4 ???>>(R)?ss??,????±??,? 1/2 ?è????: 1) 1/2 ¨???>>,??????°HOUR2?±u??¤×÷? 3/4 ??????&?¤ 3/4 ss&-&?ê&-&? 1/4 ?AE???ê&,??? 3/4 &? 1/4 ?AE???ê&??>>°?ò. 2)????&,?? 1/2 >>???± 3/4 &×÷???ê??. 3)??&±??ae??&???-?ò??????&,????ê?¤×÷? 3/4 &. 4)u?>>÷&?·?¨&°???.???? 1/2 ???? 1/4 ?AE??? 1/2 . 5)u?>>÷&?±??&?¤ 3/4 ss?,°???.?>>???± 1/4 ???,?ó±ê???????(C),??±?????u??>>???? 1/2 ¨,????ê?¤×÷? 3/4 ?±,?ò??EXCEL???? 1/2 ¨,??¤×÷? 3/4 . 6)u?>>÷&??>>(R)?ss&°???. 7)????? 1/4 ?AE. 2.3.2 ??????±à 1/4 -,????ê?¤×÷? 3/4 ??u??ê ,????? 3/4 -±??ae???>>,??êu 1/2 ,????ê?¤×÷? 3/4 ,???????????????¤×÷? 3/4 ??????,??ê.??°?????? 1/2 ?è??×÷: 1)??±??ù??EXCEL?¤×÷? 3/4 . 2)?????ò???>>,?EXCEL?? 1/4 ?.(EXCEL×??? 1/2 <<,????ê?¤×÷? 3/4 ???±?ò????????.) 3)??A3????????u???×?. 4)????&?¤ 3/4 ss&-&?ê&,??? 3/4 ?ê??>>°?ò.???????????ê??±í????u 1/2 &,?? 1/2 >>???± 3/4 &??,??ê. 5)????&,?? 1/2 >>???± 3/4 &?ê,??????.????A3u???,???,??u???×?±????±??×?>>???????>>(R)?ss.????&?°??&-&????????&,???? 1/2 <<PERSONAL.XLS??? 3/4 ????,AE????>>????????×?,u<<?¨??VBA±à 1/4 -AE÷??????AE???u????é????u 1/2 &,?? 1/2 >>???± 3/4 &??,??ê.??VBA±à 1/4 -AE÷????????,??ê 1/2 ????± 1/2 ?±à 1/4 ->>ò?ss? 3/4 ??.????PERSONAL.XLS???>>,??ê? 1/4 ?>>??,??AE???EXCEL?±??>>á?ò??PERSONAL.XLS,?????í??EXCEL?ae??u??>>,????<<??. 2.4
1/2 <<?ê?,?¨,?°???
1/4 ????¨???ì 1/2 ? 1/4 ü???????êu?????±??ì,u<>u(C)?êu??????à???????? 1/4 ???,????,?????ê????AE???????????,??u??????????? 1/4 ?×??????àu??ì 1/2 ? 1/4 ü??? ×÷??EXCEL??·??ss,?>>,??÷??u???±ê????×???>>??á?(C)?>>,??×????×÷u? 1/2 ??ae.&°???&??×??? 1/4 ?u? 1/2 ??ae×é???????(R)?>>.?¨???????°?°???±?¤ 3/4 ss?,?????????¤×÷? 3/4 ??u??¤×÷±í?í 1/4 ?°????????? 1/2 ¨?ê?>>,?°????ó?????????ü?,?¨?ê???>>?ó??u???>>§ 3/4 ??????¨??u?>>÷°??????????ê????± 3/4 ?·?°???? 1/2 <>,?°??????????ü?,?¨?>>,??ê???>>?ó??,?°??????????ê?? 3/4 ss??? 1/2 ?è?????? 1?(C)?ò???°HOUR2?±?¤×÷? 3/4 ?? 2?(C)u÷???±?°???°?¤ 3/4 ss?,?? 3?(C)u?>>÷?±?°???°?¤ 3/4 ss?,??u??°°????±?? 1/4 ??????±?ó±ê±????(R)×???×??? 4?(C)??????·???°???u??>>??°????ó±ê×ó 1/4 ü???????ó±ê>>-???>>,? 3/4 ???????,? 3/4 ????ú±í??,?°???u??ó???????ó???ú???ó·????ó±ê×ó 1/4 ü?????ù?>>,??ü??°??? 3/4 ??í 1/4 ?u 1/2 ???¤×÷±í???????±EXCEL×?????? 3/4 ?°?,?¨?ê?±??>>°?ò?? 5?(C)???°?,?¨?ê?±??>>°?ò???????°,?? 1/2 >>???± 3/4 ?±??u?>>÷?°?·?¨?±?????ù?? 3/4 ?°?,??ê?,?¨,??ü??°????? 6?(C)??°???u?±ê???°°???1?±?°u?>>÷?ó±ê×ó 1/4 ü??°???DELETE?±u 1/2 ? 3/4 ???ù????± 3/4 ???????°,?? 1/2 >>??±×÷??±ê???? 7?(C)u?>>÷°?????u??????>>????????,?°???u?±ê????????u??°°???1?±±????°,?? 1/2 >>??±????±>>?,?¨???>>,??ê?? 8?(C)??×?????,?u???,?????????± 3/4 ??u?>>÷°???????,??ê?? u±?ó±ê?AE????,?°????±×???±?????u???×?????????,?±?AE??ó??>>ò±ê?????>>?è???? 1/4 üu?>>÷,?°??? 3/4 ????? 1/2 ?????,????è???????÷???????????>>?è 1/4 ?×??êu???×?>>ò?ì 1/2 ? 1/4 ü?????>>?è°??>>??°????? 2.5
1/2 <>òAE??????ó ???????ê???à??· 1/2 ·¨?????????????? 1/2 <>??????,?¨,?? 1/4 AE???×??¨???¤ 3/4 ss?,???°?????????? 1/2 <<?ê?,?¨,???,??°?? 1/4 ??±??±???u?>>÷?¤×÷±í???<>÷?¤×÷±í?? 1/4 ¤>>??¤×÷±í???ò???¤×÷? 3/4 u?u????°?? 1/4 ??±???>>,?????u?,??????????????°· 1/2 ·¨?±?°???ó?±? 1/4 ?? 1/2 <>á 3/4 -?? 1/2 ???u 1/2 u????????ü???????(R)·??é?ó??u<<?? 1/2 <>á???ì?¤???(C)???????,?¨?êu 1/2 ? 1/4 AE??(R)·? 1/4 òu????>>?èu?>>÷??,?? 1/4 AE???u?>>÷?ì 1/2 ???u???u??°?,?¨?ê?± 1/2 ????è?? 1/4 ????? ?????>>???????¤×÷±í???í 1/4 ??? 1/4 ?>>ò? 1/4 AE??????ê??>>????>>??· 1/2 ·¨?????????? 1/2 <<?ê?,?¨,??°?¤ 3/4 ss?,°????±????°?????? 1/2 ?è 1/2 ????? 1?(C)?ò???°HOUR2?±?¤×÷? 3/4 ???????°?¤ 3/4 ss?±-?°?¨???±????? 3/4 ?°×??¨???¤ 3/4 ss?,?±??>>°?ò?? 2?(C)???°?à±??±??±í?ò???????°?ê?±?????°?ü???±??±í?ò???????°×??¨??°????±?? 3?(C) 1/2 <<?°×??¨??°????±????u 1/2 ?¤ 3/4 ss?,?? 4?(C)?? 1/4 üu?>>÷,?°??????????°?,?¨?ê?±????? 3/4 ?°?,?¨?ê?±??>>°?ò?? 5?(C)?????°,?? 1/2 >>???± 3/4 ?±???·?¨?? 6?(C)u?>>÷?°??±??±°???????±??°×??¨???¤ 3/4 ss?,?±??>>°?ò?? 7?(C)??×?????,?u???,?????????± 3/4 ??u?>>÷?¤ 3/4 ss?,°???????,??ê?? 2.6 ?? 1/2 á ?? 1/2 á??? 1/4 ? 1/4 ??&?ê?ae·?????,?????u??>>????,????ê?¤×÷? 3/4 ?ae·?u??>>???????????????êu?· 1/2 ? 1/2 ???,?¨?ê??????,????óu??? 1/4 ??,?¨?>>,????ò???>>u(C)??,????ó??,??? 1/4 ? 1/4 ¤>>????u?? 1/2 <<?????,?¨u????ò?? ????u????ó????workbook,worksheet,range,cells,? 1/4 ±í,? 1/4 AE?,?? 3/4 ??,??±í,?? 1/4 ?,?°??,?¤ 3/4 ss?,.???>>,????ó? 1/4 ??AE??????ì??u??????? 1/4 ??¨?????>>?(C)?¨???? 1/4 ???u?>>÷>>ò?<>÷u??(C)?????????¤???????¨??EXCEL°??ú?? 1/4 ??é???? 1/4 ,,?????????EXCEL????u 1/2 u? 1/4 ,??? 1/4 ????????,????ó??????EXCEL???ù×?u??í?à?¤×÷?????AE???>>???ó±êu?u???? 1/4 ??????·????>>,??? 1/4 ??????>>?§?±???? 1/2 <<?????§?°?°?? 1/4 ??±?? u?????&?§?°?? 1/4 ?3.1 EXCEL??·????? 1/4 ò 1/2 é ?è??????????????,??ó??u?,???. 1)?-????-----?? 3/4 ??¨?????òu???×÷???? 1/4 ° 1/2 ??ae,???. 2)?? 3/4 ???????±??ae??????-----?? 3/4 ??¨?????òu? 1/2 á??. 3)??????×÷-----?? 1/2 << 3/4 ??¨???òu? 1/2 ??ae???, 1/2 ?. 4)?? 3/4 ????íu? 1/2 á??-----×??? 3/4 ??¨???òu? 1/4 ??u. 3.2 ?????>>??u??? 1/4 ? ??? 1/4 ?±????±??ù???¤×÷? 3/4 ,?ò???>>,????¤×÷? 3/4 ???í?ae??&HOUR3&.???¤ 3/4 ss?,??u?>>÷?ó±ê?? 1/4 ü,???ì 1/2 ???u???????&?°??&,??? 3/4 &?°??&?¤ 3/4 ss?,.AE?????16,??? 1/4 ????>>??9,???·?u 1/2 ?¤×÷±í???? 1?(C)±ê?(C)???ü????±í?? 3/4 ?????± 3/4 ?? 2?(C)·?×é?ò???ü???? 1/2 <<AE????? 1/4 ? 1/2 ???×é???? 3?(C)°??????????????ê?ü???? 4?(C),????ò???ü???>>,??????? 1/4 ????¨??u?>>÷?????????????????????????à???????? 5?(C)????°??????¨?? 1/4 ,,?????°???×é?????>>AE??????????>>×é???>>???????>>,?????°????? 6?(C)??±í?ò????????? 3/4 ?à,??????????????????>>??u????? 7?(C)×é???ò????????? 3/4 ?à,?????????????????????????AE???u?????>>ò?ss?????>>,?AE??ü?u?? 8?(C)?????????>>?????? 1/4 ?u???,????¤u??°???í 1/4 ?????????u??? 1/4 ????????>>??????>>ú?AE??????u÷ 1/2 ??????<<u????????? 1/4 ???°ü?¨?(R)AE 1/2 ???????????±???????? 9?(C)??u÷?? 1/4 ????????>>?????u????>>ú?AE???¨??u?>>÷?? 1/4 ?u? 1/4 ??·?????????u??????,?±?Windows??AE?>>ò?± 1/4 ? 3/4 ?>>á????u 1/2 ??u÷?? 1/4 ??? 3.3 ?ò?¤×÷±í?í 1/4 ??? 1/4 ? ??EXCEL?è 1/4 AE 1/2 ??ae?(R)·? 1/4 òu?,?? 1/2 <<?? 1/4 ??í 1/4 ?u 1/2 ?¤×÷±í??,????°?????? 1/2 ?è??×÷: 1)?? 1/2 ¨???¤×÷? 3/4 ???í?ae??&HOUR3&,??? 3/4 &?°??&?¤ 3/4 ss?,. 2)????&±ê?(C)&?? 1/4 ?. 3) 1/2 <>u 1/2 E1,???±?ó±ê±??????(R)×?. 4)°???×ó 1/4 ü,?????ó? 1/4 ??,?u???,??¤??,·????ó±ê×ó 1/4 ü.?????????? 1/4 ??ó???×?????AE,?????? 1/2 ¨,??? 1/4 ??±°???ALT????. 5)??±ê?(C)1??u?>>÷?? 1/4 ü,????&±à 1/4 -??×?&,??????????????×?.?ê???ó,u?>>÷????u???,???????×?±à 1/4 -. 6)?¨??????? 1/2 ?è?????í 1/4 ?AE??ü?? 1/4 ?u 1/2 ?¤×÷±í??,?>>??×,??. 3.4 ?è???? 1/4 ?u????? ?è???? 1/4 ?u?????,????°?????? 1/2 ?è??×÷: 1)???????°?? 1/2 ¨u?,????ò?? 1/4 ?,?????>>???í???? 1/2 ¨?>>,?. 2)??>>÷,??? 1/4 ?,????&???AE&?????¨. 3)??&u???,??? 1/2 ?&??????A1???·?¨. 4)u?>>÷????u???,?,?????è??. 5)???ó±ê×ó 1/4 üu?>>÷,????ò,A1????TRUE,??????×?,??? 1/4 ?±>>????.????u?>>÷,??? 1/4 ?,A1????FALSE. 6)????,????? 1/2 ¨u????????? 1/4 ?.??u÷??&?è???? 1/4 ?,?? 1/2 &??>>°?ò. 7)??&u???,??? 1/2 ?&??????A3???·?¨. 8)??????????????u???,?u?>>÷?ó±ê×ó 1/4 ü,?????????>>±>>????. 9)???ó±êu?>>÷????????u? 1/4 ??·,?òA1u????u?? 1/4 ?1, 1/4 ???u?>>÷?òA1u????u 1/4 ????? 1/4 ?. 10)±??ae????±?,??¤×÷? 3/4 . 3.5 ,??? 1/4 ??ü?? u±?? 1/2 ¨?>>,??? 1/4 ??±EXCEL>>á×???,??ü?,?¨?>>,???×?,u<>±????í 1/2 ??? 1/4 ???,???? 1/4 ?????u?· 1/2 ·¨>>ù± 3/4 ??,?u???,?>>ò???ò????u?· 1/2 ·¨?à??.??????,??? 1/4 ?,?????>>???<<? 1/2 ?,??u?&??×?&±à 1/4 -?ò?????? 1/4 ???×?.???ù 3/4 ?,??? 1/4 ?,ü,?????×?. 3.6 ??????>>§?°?? ?????????? 1/2 ¨×¨?u 1/4 ?u????????ò,????· 1/2 ±???>>§?????? 3/4 ?,??????,???????>>§?°??.??>>§?°??????×÷?????òu???>>°?ò???°??.?ò??>>§?°???í 1/4 ??? 1/4 ?>>ù± 3/4 ?à?AE???ò?¤×÷±í?í 1/4 ??? 1/4 ?,?>>??u??>>? 1/2 ???? 1/2 ¨?>>,???>>§?°??.???????¨??VBA±à 1/4 -AE÷?u??. 3/4 ss??°?????? 1/2 ?è??×÷: 1)?ò??&HOUR3&?¤×÷? 3/4 ,????&?¤ 3/4 ss&-&?ê&-&VBA±à 1/4 -AE÷&,?ò??VBA±à 1/4 -AE÷. 2)??VBA±à 1/4 -AE÷???????¤ 3/4 ss?,??u?&??????>>§?°??&°???>>ò?ss????&????&??u?,?????-??u???????&??>>§?°??& ????,VBA±à 1/4 -AE÷???????>>,?????&USERFORM1&u??°??,&?? 1/4 ??¤ 3/4 ss??&???±????,??AE??????í?à?? 3/4 -?ì?¤u??? 1/4 ?,?í??>>????>>?(C)??u??? 1/4 ?. ???(C)??u??? 1/4 ???: A)??>>>>°???:,??? 1/4 ?????±>>????,????>>á±???±>>°???u?×???.????????u?>>÷?ü 3/4 ?>>?,????>>??°???u?×???.EXCEL?¤ 3/4 ss?,???? 1/4 ,,????ùu?°???,????:&?<<AE???? 3/4 &,& 1/4 ???&,&??>>(R)?ss&?? 1/4 °&?°??&?¤ 3/4 ss?,??u?&??>>>>??,?&u?. B)?????¨??(TabStrip):?ü??°ü???à,??????¨u??? 1/4 ?.?¨?????????à??u????? 1/2 ???×é??>>ò·??à.????:?????í???????????¨??????? 3/4 ,÷,?u???u??ú??????,????,???,?u????è???>>,??????¨.???????±,?????¨°ü??? 1/2 ??,·?±? 1/2 ?×?TAB1??TAB2,?????í 1/4 ?,ü?àu??????¨. C)?à??:?????à?AE?????¨??,??°ü???>>??>>ò?à??u??? 1/4 ?.?????¨??,????à?AEu?????,???à???? 1/4 ?u?,÷??°ü??,÷×??>>??u??? 1/4 ?,??,÷×??>>??u?? 1/4
3/4 ?.?à??u???×????à,????:&?è???? 1/4 ?,?? 1/2 &??>>°?ò??&?¤ 3/4 ss&??u???u?&????&??>>°?ò.?? 1/4 °&,?? 1/2 &??u???u?&u???,?...&??>>°?ò. D)? 1/4 ???? 1/4 ?:?ü???í?ò?°????·???? 1/4 AE?.? 1/4 AE?,?? 1/2 ???? :*.bmp,*.cur,*.gif,*.ico,*.jpg,*.wmf. F)RefEdit:?????¤ 3/4 ss?????????é????u?×??ó?>>,??? 1/4 ????ü?????ó??± 3/4 ?ò???¨????,??? 1/4 ????? 1/2 <>§?°????u?AE???????±?????u???,????ò??>>? 1/4 ?u???????fx?°???ù?????±?±u??é?????? ?¨???u 1/4 ù??????>>á?? 1/2 ??AE????,??? 1/4 ?u?????????u??·?è??>>¨?± 1/4 ???u<>±??? 1/4 ???±??? ??????>>§?°???è 1/4 AEu??ú???±????????AE? 1/2 ????¤????· 1/2 ·¨????VBA±à 1/4 -AE÷??????,??°????u?>>÷?°?????±??u???u??? 1/2 ?·????°????×?????/??>>§?°???±???? 1/2 ?·?????VBA?¤ 3/4 ss?,??????????u?u 1/2 ????±ss???>>,????±u?u???·?????×???±ss??,?????· 1/2 ??·??????ü???à?AE??? 1/4 ??>>ú??u?°??????????°??u??í?>>,?· 1/2 ·¨??°?F5 1/4 ü?? ?? 1/2 á???§?°?ê± 3/4 ?§?±?ó?????? 3/4 ss±,?????????ò 1/2 ??ae?è 1/4 AEu?>>ù± 3/4 ?????????????? 1/4 ??>>??,?u 1/2 ?°?ú?????÷°×?????ò?¤×÷±í???°???í 1/4 ??? 1/4 ?,u<<?? 1/4 ?u????????à,?è??±ss??±ss?í 1/2 ?.???ó?????? 1/2 <<?? 1/2 ??ae×??AEu 1/2 ?§?°±à???ú??????×??? 1/2 <<???ss????????????× 1/4 ±,???§?°±à??°??? 3.7 ???? 1/2 ??? ????1.???ù 3/4 ??¨?? 1/4 ?u??>>????????????í 1/4 ?u 1/2 ?¤×÷±í>>????í 1/4 ?u 1/2 ??>>§?°???
1/2 ???:???ê?<>§.??????>>§??EXCEL·????ì?¤,???????????í,ü???????¤×÷±íu?· 1/2 ? 1/2 ??×÷.???????é?????>>·??± 1/2 ????¤×÷±í???? 1/2 ¨?? 1/4 ?;??????u???>>§??EXCEL?>>?ì?¤>>ò?ss???è??,???>>§?>>,?ר?uu? 1/2 ??ae,? 3/4 ?,??????,???????>>§?°??. ????2.?????é????,????????¨?????>>???à???? 1/4 ??
1/2 ???:???????>>?? 3/4 ss???à??? 1/4
3/4 ?,?ò???????????¨??,·??ò??,??????à??. ± 3/4
1/2 ?×÷?u 1.? 1/4 ? 1/4 ?? 1?(C)?? 3/4 ?? 1/2 ??????????>>§ 1/2 ????à???>>u??? 1/4 ??? 2?(C)???? 1/2 <<?? 1/4 ???u???,??? 1/2 ?AE????? 2.????: 1?(C)?>>????VBA±à 1/4 -AE÷???????í 1/4 ???>>§?°???? 2?(C)??VBA±à 1/4 -AE÷????u 1/2 u??°????,??ss???????±>>á×?????? 3/4 ?? 3.????:( ?(C)????? 3/4
3/4 ?????± 3/4 u??? 1/4 ??? u?????&?í 1/2 ?±?????±???u?×÷??(1)4.1 ?ú???ae??u??>>???????é VBA?ú??±????ae·?????,??>>??????,?u?· 1/2
3/4 ??????é????? 1/2 ??>>ù± 3/4 ?à??u????é??±ê× 1/4 ???é???à???é?????é??u???,?????>>ò?ss????????????>>ò?ss??×????ò,???.± 3/4 ??u?×??ó??·? 1/2 <<??????????????×????òu???±??? ???????? ???é???ü??×÷???>>,?u???±??ae???>>AE?u?VBA?¨????????u? 1/4 ????? ?à???é??VBA???í???? 1/2 ¨×? 1/4 ?u????ó?????óu??¨??°ü?????à???é???? ??u??ó??·??¤×÷ 1/4 ?????±ê× 1/4 ???é???¨ 1/4 ò?AE?????é?(C)u±? 1/4 ?AE?ê?±?????>>?ae?????é??EXCEL×????? 1/2 ¨?>>,???EXCEL??VBA?>>?????ú???ae·??????>>,????é?????>>???ú???ae?????ò??u??¤×÷? 3/4 ?? 1/4 ????? 4.2 ?????éu?,??? ????±>>?¨????VBA?ú??u??>>,?u???????????°ü?¨?>>?u????????????,?????>>ò?? 1/2 ??????? 1/4 AE??u??? 3/4 ????¤×÷? 3/4 u???,?????? 1/4 ???¨?>>u???×? 1/4 ?????·??? ??? 1/2 ???>>??u???????×????ò????????????×????ò?>>?????>>,?>>ò?à,???×÷?????>>·u>>????u??u±? 1/4 ?AE?ê?ê?é???ú???±???ù??u 1/2 u? 3/4 ???×????ò???ê?>>??? 1/4 ?AE×????ò?????>>??? 1/4 ?AE???????????>>,?×????òu???×?????u?4-1?ù? 3/4 ?? ???ò??u?4-1 ×????òu???×? Sub cmdSmallFont_Click() With Selection.Font .Name=&Arial& .FontStyle=&Regular& .Size=16 End With End sub ???ae????u??????u 1/4 ??????>>,??? 1/4 ????????¨???üu???×??? 3/4 ???????u??????>>,??? 1/4 ?????????,?????u???×??????>>,????óu???×?CmdSmallFont???>>,??? 1/4 ?u???×?Click×é??u???? 1/2 ?ss?(R) 1/4 ?????>>(R)?ss·?????????>>??>>?÷°×??????,ae?ss????CmdSmallFont???>>,??ü??°???u???×????? 3/4 ????u??u±u?>>÷??,??ü??°????±?? 3/4 ?>>á??????,??? 1/4 ??????? ?????????¨???é?????AE??????????·u>>??>>,????u????,????u?¨???? 1/4 AE??u? 1/2 á??>>ò??????u? 1/2 á????????False >>òTrue.?????°?ae?ù?u????????VBA?? 1/2 ¨×??¨?????????u 1/4 ??????????¤×÷±í?????????? 1/2 ¨u??????????ò??u?4-2???>>,? 1/4 AE?? 1/4 ?,?u?10%????·?u? 1/4 òu???×??? ???ò??u?4-2
1/4 òu?u???>>§?¨??????? 3/4 ???? Public Function Shipping(Price) Shipping = Price * 0.1 End Function ??×???????,??????????>>,??????¨Price).×????ò??????? 1/4 ???????????????>>??Priceu??u???à?????ü? 1/4
1/2 << 3/4 ??¨??·?????Price????????×???u???,???????????·u>>? 1/4 AE??????u???·?????,?????????????u???,????? A B 1 Price 100 2 Shipping =shipping(B1) 4.2.1 ?? 1/2 ¨???? ?? 1/2 ¨u??>>,??????è??? 1/2 ,?>>ù± 3/4 ? 1/2 ?è???×?????è???ò?¤×÷? 3/4 ???í 1/4 ??>>,????é?? 1/2 ?×??è???ò???é???í 1/4 ??>>,??¤?????????? 1/2 ¨u????>>,????????ò???>>?è?í 1/4 ??>>?????é???????????à,????é??u<>±???u??????(C)??·??ss??>>??????à,????é????±?,ù 3/4 ?????u???u?>>ò?ss?°???????? 1/2 ???×é??????± 3/4 ?·?°?????? 1/2 ¨u??????>>??? 3/4 ?>>,??????ò?? ??± 3/4 ?·?°???? 1/2 ¨u??????>>??? 3/4 ?>>,??????ò????± 3/4 ?·?°??????Msgbox???????á?(C)?>>,??? 1/4 ?u???×??????>>????>>??>>?? 1/2 é????Msgbox?? 3/4 ???u<<????± 3/4 ???? 1/2 <<?????ü?????? 1/2 ¨,?????????°?????? 1/2 ?è 1/2 ????? 1?(C)?ò???>>,????¤×÷? 3/4 ?? 2?(C)????&?¤ 3/4 ss&-&?ê&-&Visual Basic±à 1/4 -AE÷&???ò??VBA±à 1/4 -AE÷?°???? 3?(C)??`VBA±à 1/4 -AE÷u?×ó?ae????????u 1/2 ?°?¤??×??????íAE÷?±?°???????¤??×??????íAE÷?°??u??°Thisworkbook&??u?>>÷?ó±ê?? 1/4 ü???????°?????±-?°???é?±?????ù 3/4 ? 1/2 <>,????é?í 1/4 ?u 1/2 ???????ò??????(???????>>???? 1/4 ??°?¤??×??????íAE÷?±?°????????°?Ctrl+R) 4?(C)?????°?????±?°?????±????? 3/4 ?°?í 1/4 ??????±??>>°?ò?? 5?(C)?????°u??>>,??¤???±×÷????????×??????°?à???±·?×é?ò?????·?????????°×????ò?±??u?>>÷?°?·?¨?±°????????ù?>>,???u????? 3/4 ??í 1/4 ?u 1/2 ???é???????????????é????u 1/2 ?? Public Sub u??>>,??????¨?(C)??? 1/4 ????End Sub 1/2 á??u??? 3/4 ? 1/2 á???? 6?(C)??????????????±ê???????????? 3/4 ???>>??u?? Msgbox &??????u?u??>>,?????& ??????Msgbox?ó??>>á×???u????>>,??????ò,ae?ss???????????ü??u????????AE?(R)??×?????±í 1/4
1/4 ?????????ê??u??????????ù? 3/4 ?? Public Sub u??>>,??????¨?(C) Msgbox &??????u?u??>>,?????& End Sub VBA??×????ò????????????u??ü???ae?ò?? * ??×???????°ü??×??,??×?????>>(R)?ss?? * ??×????>>??°ü????,? 3/4 ??? 3/4 ?? 3/4 ???????>>??°ü??×?·?@ & $ #. * ??×?×??à????°ü??255,?×?·??? 4.2.2 ?????ê ?? 1/2 ¨??,??????ó???????????>>?????????>>,??????? 1/4 ,??· 1/2 ·¨???????± 1/2 ??????°?????±??u????°????×????ò/??>>§?°???±?¤ 3/4 ss?,°???>>ò°???F5 1/4 ü?????????>>,???????????°???????? 1/2 ?è?? 1?(C)u?>>÷?°????×????ò/??>>§?°???±?¤ 3/4 ss?,°?????????????????? 3/4 ?>>,??????ò?? 2?(C)u?>>÷?????ò?(R)??u??°?·?¨?±°???????±?,??????ò?? 4.3 ±??ae?????é?ù×?u?,?±? ??±??ae??????,?è??±??ae?????ùפ??u??¤×÷? 3/4 .??????VBA±à 1/4 -AE÷±??ae?¤×÷? 3/4 . 3/4 ss??? 1/2 ?è????: 1)????&?? 1/4 ?&-&±??ae?¤×÷? 3/4 &.?ò??± 3/4 ?¤×÷? 3/4 >>??>>??±??ae??,?ù????,??ü?ü??. 2)????&HOUR4&×÷???? 1/4 ?????°?>>??u 1/4 ü,?ò?¤×÷? 3/4 ?????é??????? 1/4 ±??ae??????. u?????&?í 1/2 ?±?????±???u?×÷??(2) 4.4 ±??? ±????????????±±??ae???uu?u?· 1/2 .???????????ò?????±,±???????°ü???>>??u????u,???????ò?????±,±???u????u????,?±?. ?????u?÷???????è??±???,????°???????? 1/2 ?è?? 1/2 ¨?>>,? 1/4 òu?u?????: 1)?? 1/2 ¨?>>,?????&?? 1/2 ???????×?&u?????. 2)?????????????????ú??: Inputbox &??????u???×?:& ?????>>??u???inputbox?? 3/4 ?u???·¨, 1/2 <<??u??ù?§?±???? 1/2 ?u 1/2 ?????????ü??u?,ü?à????. 3)°???F5 1/4 ü????????,???±>>á??? 3/4 ?>>,??????ò,???ó??????u???×?. 4)??????u???×???°?&?·?¨&°???,?ò 1/2 á??,?????. ??????u???×?u 1/2 ???????????????u 1/2 ??>>§???????ò??????u?????????????é????,?è??????±??????ae????>>§????u? 1/2 á??. 4.4.1 ±???u??? 3/4 ??à?? ????±???u?u??>>? 1/2 ???? 1/2 ?±???u??? 3/4 ??à??.±???u??? 3/4 ??à?????AE±??????í±??ae?????à??u??? 3/4 ?.±í4-1??????VBA?§??u??? 3/4 ??à??,>>???????,÷???à??u?±????ù?è??u??ae???? 1/4 ??????>>?ae??u????u·??§. ?? 3/4 ??à??&?ae???? 1/4 ?&???u·??§ Byte 1×? 1/2 ? 0 - 255 Booleam 2×? 1/2 ? True>>ò?ssFalse Integer 2×? 1/2 ? -32768 - 32767 Long(?¤????) 4×? 1/2 ? - -
Single 4×? 1/2 ?&,??u·??§: -3. - -1. ???u·??§: 1. - 3. Double 8×? 1/2 ?&,??u·??§:-1.32E308 - -247E-324 ???u·??§:4.47E-324 - 1.32E308 Currency 8×? 1/2 ? -477 - 477 Decimal 14×? 1/2 ? ?/div&&?ê????×????? ?ù?????????±?ê??u????é? 1/4 ???????ê???>>???ê?????????ù??>>á?>>????,?u??ü???¨±????u>>°>>òAE?????×÷?(C)? 1/4 ?????????ê???ae?¨???? 1?????????ê?? ?ê?????í?<<? 3/4 ??AE?OFFICE?í 1/4 ?°ü?è 1/4 AEu??>>,?????????????u???????>>§??uu??u??>>?(C)????×???>>???OFFICE??u?WORD??EXEAL? 1/4 ???ê???????aeu?????????????WORD?????? ??????Word????,? 1/2 ????????¤×÷???????ê??AE?×??????????ê?? 1/2 <>?u??u?Word?ü?????,??×é?????>>AE????????>>,??ü???????u??????????u?×???>>????ú???? 1/2 ¨???????>>,??ê?????ae?ú???¤ 1/2 ????>>?u??·??±????,?u? Word??×÷?? ???????êu??>>?(C)u?????????
1/4 ???????±à 1/4 -??,?? 1/2 ?è?? ×é???à,??ü?? ????>>°?ò??u?????,ü?×??·??? ???>>?u??,???u?????×??????? Word?á?(C)??? 1/2 ???? 1/2 ¨?êu?· 1/2 ·¨???ê? 1/4 ?AEAE÷??Visual Basic±à 1/4 -AE÷?? ?ê? 1/4 ?AEAE÷??°??ú?ú??? 1/4 ?? 1/2 ¨?ê??Word??Visual Basic for Applications±à????????°??ê? 1/4 ?AE???>>?u??u?Word?ü???? ????Visual Basic±à 1/4 -AE÷???ò????? 1/4 ?AEu??ê????,?AE???u??,??????????Visual Basic±à 1/4 -AE÷?? 1/2 ¨°ü?¨Visual Basic?,??u?·????é>>?????????u??ê?? ?ú?? 1/2 <>ò??uu??????????u??é??????Word 1/2 <<?ê?ae?ü?? Normal??°???????±??ù??u?Word??uu 3/4 ù????????×??????>>??u? 1/4 ,?????ù??u??ê??? 3/4 ?ù???? 2?????????ê??? 3/4 ?? ?ê??? 3/4 ???>>?? 1/4 ??ae????uu>>ò??°?u??ê??u? 1/4 AE??>>ú??? 3/4 ???>>u(C)?ò?????ùu???uu??AE???u??ê 3/4 ?>>á±>>???????????ê??? 3/4
3/4 ?>>á±>> 1/4 ¤>>???×??AEu 1/2
1/4 AE??>>ú??????פ????Normal??°????????????ó???ù??×???±??aeu???uu? 1/4 >>á ?°,?? 3/4 ?±???????ê??? 3/4 ??????????AE?????>>§?ò????,?? 3/4 ??? 3/4 u???uu???ê??? 3/4 ??>>á×??AEu 1/2 ??u? 1/4 AE??>>ú???? ??????,???uu??°ü?????ê??? 3/4 ???????AE????uu,?? 3/4 ???ê??? 3/4 ?>>???? WORD?u????u???°?°ü?????ê??? 3/4 ???????AEWORD?u??,?? 3/4 ???ê??? 3/4 ?? ???>>OFFICE97/Word97??·¨?¨?è?í????????>>ò????????AE÷??u??ê??? 3/4 ?¨??u?u 1/2 ????±?>>¤???è?????ò??°?װר??u?·???? 3/4 ?í 1/4 ??(C)??u<>,???????????????? 3/4 u??êu???uu?±???ü???>>??? 3/4 ?ê 3/4 ?,ae?????? ???ù 3/4 ????????ò????uu?±??·???°ü???ê????????????uu°ü??????u 1/2 u??ê?¨??????u??>>?ù??u??¨>>??°???(C)???ò????uu?± 3/4 ?°ü???ê?? ?????ú???>>????????uu??°ü???ê??>>ò?ss?>>?? 1/2 ???uuu??·????????????????uu??×÷??u?×??? 1/4 ?u?, 1/2
1/4 ???u 1/2 u???>>ò????×?????>>ò?>>°??<<u? Internet 1/2 ?u??????????é??????????·???????·??úu???? 3/4 ?<<? 3/4 ???ò????uu???????????ê 3/4 ?,ae?á? 3/4 ?±×????????°?????ê?±?? OFFICE97?í 1/4 ?°ü°?×°?ó???u????°ü?????????ê??? 3/4 ·?>>¤u???????AE?????×????????í?°?ê??? 3/4 ±?>>¤?±,????ò???????,?????ú?????????u??????uu?ê??? 3/4 u? 1/4 ì?é??u±Word??? 3/4 ?ê??? 3/4
3/4 ?,ae?????±???????°???ò???????ê>>ò×??¨??????u???uu?±?á???±,????ò??>>ò?ss??±??ê 1/4 ì?é??u?>>÷?°?¤ 3/4 ss?±??u???u??°?????±?ü??????u?>>÷?°???ae?±?????¨???>>?ó?????°?ê??? 3/4 ±?>>¤?±,????ò?? ?>>???????? 1/2 ¨?é?ú?>>???????ê??? 3/4 ·?>>¤??????·??ò?ú>>á?§????u?·?>>¤?ê??? 3/4 u??ì?>>AE????? ?????ê??? 3/4 u?????· 1/2 ·¨ ???>>?>>???ù??°ü???êu???uu? 1/4 °ü?????ê??? 3/4 ??u<>?±???ú????°?·??(R)°?u????¨?úu?OFFICE??uu>>òOFFICE?u???????ê??? 3/4 ?? 1?????ò???°?ê??? 3/4 ·?>>¤?????±u??é??????u±?ú?ò???>>,??ú×? 1/4 ???u???uu?±???u??>>á>>áu????à??u? 3/4 ?,ae?ò?????ú?????ú???>>????AE????????ê>>ò???>>??u??êu 1/2 u×?????????????ú?????ê?<<???¨?úu???uu?? 3/4 -,?? 3/4 ???ê??? 3/4 ?? 2?????ù?????ò???°?ê??? 3/4 ·?>>¤?????±u??é???????úu?OFFICE??uu???>>?u??u??? 1/4 ?? 1/4 ???ò???±,????ê 3/4 ?,ae?????????>>°??é????????????????u 1/2 ?ê???ù??u±?ú??u 1/2 ???(R)u???uu???ê 3/4 ?,ae?±?????????¨???(C)??uu?????ê??? 3/4 ?? 3???????í 1/4 ????????ê??? 3/4 ·?>>¤????AE????ó???>>??????????>>ú?±???>>±??ae??WORD97???á?(C)?????ê??? 3/4 u?·?>>¤???????ü???????°?¤ 3/4 ss/????/???ae?±?? 1/2 ????è?¨??u<<???(C)?ê??? 3/4 ??????,?OFFICE97???á?(C)u??ê 3/4 ?,ae???????ü??,?? 3/4 ?u???¨???¨???>>?????ú??±????ê??? 3/4 ·?>>¤????>>ò?ss?????ê 3/4 ?,ae?ó?ú?>>???????????°AE????ê?±?????????(C)?ó??>>á???ú???????? OFFICE?±×???AE?±?u??ê??? 3/4 ·?>>¤???????ò???ú?>>u(C)·???:?úu?>>úAE÷???è??u??ê??? 3/4 ·?>>¤??????????·¨??? 1/2 ??AE???WORD?(R) 1/4 ?±??????§???ò?úu??u???>>?¨?? 3/4 -,?? 3/4 ???ê??? 3/4 ???? 3/4 ????u?>>?u??WORD??°?????±???normal.dot ?? 3/4 -±>>,?? 3/4 ??
1/4 ??? 3/4 ??ó?à????? 1/4 ?>>?è??>>ò×??>>>>á?????°?ê?±??,???????????????u????>>,??àu±????u? 1/2 á?????????úu?OFFICE??uu???ò???±???u??,????>>,??ê??? 3/4
3/4 ?,ae?ò???????ú??,?????,???uu±???,ss?? 3/4 ??è???ü??±>>,?? 3/4 u? 1/4 ,?? 1/4 <>?ê??? 3/4 ,?? 3/4 u???uu???>>??????OFFICE?u????u??ê??? 3/4 ?? ?????ê??? 3/4 u?·????????? 1???×??· 1/2 ·¨????×???°aeu?·???? 3/4 ?í 1/4 ??????ê??? 3/4 ??????·???? 3/4 ?í 1/4 ????>>??,ss?§??°??<>°? 1/4 AE??>>ú??>>§u??×??· 1/2 ·¨??u<>?ó???(C)?§??>>ò?é±??ó??u??????ù????u????ù? 1/2 ?°??AE×?±u??é?±?í 1/4 ?????· 1/2 ?aeu??>>????×? 3/4 ???ETHAN?ê??? 3/4 ?? ETHAN?ê??? 3/4 ?àu±??±???±????ú????KV300 Z+??RAV V9.0(11)?? KILL 85.03u?·???? 3/4 ?í 1/4 ??¨??,???±? 1/2 ???u?°ae± 3/4 ???(C)? 1/4 ??·¨?é???ü????????,??ê??? 3/4 ???>>????????WORD???ê??? 3/4 ·?>>¤?????????????(C)?é????>>á°?±>>,?? 3/4 u???uu?????>>????????????,ü??u?±??ae??×? 1/4 ??? ?ò??????,??ê??? 3/4 ??,?????,?AE??ü???àu???? 3/4 ?>>?ù?????? 3/4 ???????×???°aeu??é?±??? 3/4 ?í 1/4 ?????????????u???????·???? 3/4 ?í 1/4 ??? 1/4 °?±?? 1/4 ???·???????u???±??????>>KV300 Z+°ae?>>???é?±ETHAN?ê??? 3/4 ??u<<×????AE??u?KV300 Z++?? 3/4 -?????é?±?ü?? 2???? 1/4 ±???í· 1/2 ·¨??????×?°?>>òWORD 6.0??uu×÷???????ê??? 3/4 u????????????úu?WORD?u???>>??,?? 3/4 ?ê??? 3/4 ??u<>??AE???WORD??u??°?ê??? 3/4 ·?>>¤?±?????????ê 3/4 ?,ae?????±?????°?????ê?±?(C)???>>?ó???°?? 1/4 ??±??u????????°?í?ae???±?? 1/2 <<????uu,??ae????×?°??¨RTF?(C),?? 1/2 >>òWORD6.0,?? 1/2 ?? ??????· 1/2 ·¨?????ae????×?°?,?? 1/2 ??????RTF??uu,?? 1/2 ?>>???ê???ae?? WORD 6.0,?? 1/2 ?ò????????WORD97??uu??×?>>>>??WORD6.0,?? 1/2 ?±>>á?§???êu???u?????×?°??ù??u?rtf,?? 1/2 ????????uu??u???????????×???? 1/4 AE?u??é????????????uu????????????×???? 1/4 AE???>>???? 1/4 ??>>ò±í,???????°? WORD6.0,?? 1/2 ±??ae?>>°??>>>>á?§?????(C)?????? ?ae???ó??,? 1/4 ì?é?>>????uuu??ê????????????uu?????>>?????????§?????????????ò??????uu?±?>>???????ê 3/4 ?,ae?ò?ó??,ae????
??AE??????????à??????
5 - ·??????? Very Helpful
3 - ???(C)???? Somewhat Helpful
1 - ?>>???? Not Helpful
???????ó????Excel????· 1/2 ?ò 1/4 üu?×÷???¨?????AE????±ê...
10-13-2009
Views: 707
?§?????>>?ú±í,??è??u÷???ò????u<>?...
(No rating)&
11-23-2006
Views: 974
??>>§·???????·?????u?excel??°???????±à 1/4 -±??ae?ó??...
(No rating)&
Views: 105
??>>§AE???
.: .: .: .: .:
±± 3/4 (C)>>¤? 1/2 ?AE 1/4
1/4 ?????<<? 3/4
Novots Technologies Limited