{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}
free FREE

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

{{email ? __('Got it!') : __('Restock Alert')}}

We will notify you by email when the item back in stock.

Cancel
Yami

Jingdong book

Excel VBA应用案例速查手册(双色版)(含CD光盘1张)

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Excel VBA应用案例速查手册(双色版)(含CD光盘1张)

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}
Ends in
{{ itemCurrency }}{{ item.valid_price }}
{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}
{{ itemDiscount }}
{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}
{{ itemCurrency }}{{ item.valid_price }}
Sale ends in
Sale will starts after Sale ends in
{{ getSeckillDesc(item.seckill_data) }}
{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details
Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.
Sold Out

Details

Full product details
Content Description

《Excel VBA应用案例速查手册》是Excel VBA入门的经典教材。全书共分17章,主要是以一些基础而简短的VBA实例来对Excel VBA中的常用对象及其属性和方法进行讲解,包括应用程序对象、窗口、工作簿、工作表、单元格和单元格区域、图表、数据透视表、形状、控件、格式化操作、文件操作等应用示例。这些例子都比较基础,很容易理解,因此很容易调试并得以实现,让您通过具体的实例来熟悉Excel VBA编程。本书在Excel 2010版本中操作编写,本书为每个应用范例设置了“范例说明”、“范例步骤”、“知识扩展”和“提示”等模块,既容易理解,又可以让读者在学习VBA理论知识与实践之外拓展知识面。
Catalogue

第一部分Excel VBA基本语法
第一章宏与VBA
第一节宏
范例1-1-1显示和隐藏“开发工具”选项卡
范例1-1-2设计图书卡
范例1-1-3把宏指定到图片
第一节宏
范例1-1-1显示和隐藏“开发工具”选项卡
范例1-1-2设计图书卡
范例1-1-3把宏指定到图片
范例1-1-4把宏保存到文件
范例1-1-5删除宏
范例1-1-6对宏安全性进行设置
第二节VBA
范例1-2-1打开VBE
范例1-2-2从VBE返回Excel
范例1-2-3通过工程资源管理器插入一个宏模块
范例1-2-4通过工程资源管理器删除一个宏模块
范例1-2-5为宏代码加密
范例1-2-6向标准工具栏中添加立即窗口命令
范例1-2-7在VBA中对宏进行编辑优化
第二章语法入门
第一节面向对象的程序设计
范例2-1-1创建一个类模块
范例2-1-2根据存在的类创建对象
范例2-1-3在对象浏览器中查看类及对象
范例2-1-4设置窗体尺寸及位置
范例2-1-5使用代码关闭当前工作簿
第二节数据与数据类型
范例2-2-1为变量和常量命名
范例2-2-2声明变量
范例2-2-3数据类型
范例2-2-4用户自定义类型
范例2-2-5强制声明变量
范例2-2-6使用变量
范例2-2-7使用局部变量
范例2-2-8使用全局变量
范例2-2-9对象变量的使用
范例2-2-10自定义常量的使用
范例2-2-11内置常量的使用
范例2-2-12使用一维数组
第三节运算符与表达式
范例2-3-1算术运算符及表达式
范例2-3-2比较运算符及表达式
范例2-3-3字符串运算符及表达式
范例2-3-4逻辑运算符及表达式
范例2-3-5引用运算符及表达式
范例2-3-6其他运算符及表达式
第四节语句基础
范例2-4-1使用MsgBox函数输出
范例2-4-2使用InputBox函数输入
范例2-4-3If…Then语句
范例2-4-4If…Then…Else语句
范例2-4-5阶梯电价的计算
范例2-4-6企业信用等级的判定
范例2-4-7使用While…Wend计算从1到100的累加值
范例2-4-8使用Do…Loop计算从1到100的累加值
范例2-4-9使用For…Next计算从1到100的累加值
范例2-4-10计算所选工作表区域之和
范例2-4-11使用嵌套循环解决数学问题
范例2-4-12使用On Error进行错误处理
范例2-4-13使用Resume语句进行错误处理
第五节过程与函数
范例2-5-1调用具有多个参数的 Sub 过程
范例2-5-2调用Fuction过程
范例2-5-3在Fuction过程中使用可选参数
范例2-5-4在Fuction过程中使用不定参数
范例2-5-5自定义工作表函数
范例2-5-6使用VBA的内置函数
第二部分Excel VBA对象模型应用
第三章应用程序操作
第一节Application属性操作
范例3-1-1显示活动打印机的名称
范例3-1-2调用“另存为”对话框
范例3-1-3检查并显示编辑栏
范例3-1-4显示或隐藏整个Excel的滚动条
范例3-1-5设置Excel窗口的大小和位置
范例3-1-6设置Excel为全屏模式
范例3-1-7检查并隐藏Excel应用
范例3-1-8返回窗口状态,并根据需要设置是否最小化
范例3-1-9在VBA中使用工作表函数
第二节Application对象的方法操作
范例3-2-1使用“打开”对话框打开文件
范例3-2-2与其他应用程序通信
范例3-2-3为宏程序指定快捷键
范例3-2-430秒后运行指定过程
范例3-2-5退出Excel
第四章窗口应用
第一节Window(s)属性操作
范例4-1-1修改并获取当前窗口的标题
范例4-1-2显示单元格中的公式
范例4-1-3显示和设置工作表中的网格线
范例4-1-4显示和隐藏工作表标签
范例4-1-5根据用户要求调整窗口显示比例
范例4-1-6自定义窗口
范例4-1-7隐藏窗口中的零值
范例4-1-8选择合适的视图方式
第二节Window对象的方法操作
范例4-2-1保存并关闭工作簿窗口
第五章工作簿应用
第一节Workbook属性操作
范例5-1-1删除工作簿中所有的图表工作表
范例5-1-2设置共享工作簿为自动更新
范例5-1-3保存共享工作簿的历史版本
范例5-1-4在共享工作簿中启动修订功能
范例5-1-5隐藏工作簿中的所有图形
范例5-1-6显示工作簿名称
范例5-1-7检查工作簿中是否存在宏项目
范例5-1-8检查工作簿是否以只读方式打开
范例5-1-9检查工作簿是否建议以只读方式打开
范例5-1-10检查工作簿保存后是否发生过修改
范例5-1-11显示工作簿中第一个工作表的名称
范例5-1-12检查工作簿的自动恢复功能
范例5-1-13取得当前打开的工作簿数
范例5-1-14为工作簿设置打开密码
范例5-1-15检查工作簿是否有保护
范例5-1-16检查并保护工作簿
范例5-1-17为工作簿设置写保护密码
第二节Workbook对象的方法操作
范例5-2-1激活工作簿
范例5-2-2将主题应用到工作簿
范例5-2-3通过ChangeFileAccess方法设置工作簿权限
范例5-2-4Excel服务器应用
范例5-2-5不保存退出Excel
范例5-2-6打印当前工作簿中的前3页
范例5-2-7保护当前工作簿
范例5-2-8禁止指定用户与共享工作簿的连接
范例5-2-9保存当前工作簿中的更改
范例5-2-10另保存当前工作簿中的更改
范例5-2-11将当前工作簿以副本保存
范例5-2-12取消工作簿保护
范例5-2-13新建工作簿
范例5-2-14打开工作簿
范例5-2-15关闭工作簿
第三节Workbook(s)对象的事件操作
范例5-3-1保存成功后提示
范例5-3-2保存前确认是否保存
范例5-3-3在工作簿中创建图表时提示
范例5-3-4新建工作表后提示工作表数量
范例5-3-5打开工作簿时提示工作簿名称
第六章工作表应用
第一节Worksheet属性操作
范例6-1-1删除工作簿中所有的图表工作表
范例6-1-2删除当前工作表中的所有批注
范例6-1-3隐藏除第一个工作表外的其他工作表
范例6-1-4创建目录工作表
范例6-1-5删除工作表中的空行
范例6-1-6限制工作表的滚动区域
范例6-1-7保护工作表
范例6-1-8页面设置
第二节Worksheet对象的方法操作
范例6-2-1选择工作表
范例6-2-2激活工作表
范例6-2-3把工作表复制到指定位置
范例6-2-4删除空工作表
范例6-2-5将工作表导出为PDF文档
范例6-2-6在现有工作表之后插入工作表
范例6-2-7将当前工作表移动到其他工作簿
范例6-2-8复制工作表中的内容数据
范例6-2-9向工作表中粘贴网页中的文字
范例6-2-10建立数据透视表
范例6-2-11为工作表设置背景
第三节Worksheet(s)对象的事件操作
范例6-3-1验证后编辑工作簿
范例6-3-2改变更改内容的颜色和字体
范例6-3-3在工作簿中创建图表时提示
范例6-3-4快速输入默认值
第七章单元格应用
第一节Range对象的属性操作
范例7-1-1设置单元格对齐方式
范例7-1-2自动向下行添加当前日期
……

Specifications

Brand Jingdong book
Brand Origin China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use
Add to favorites
{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}
{{__("Buy Directly")}} {{ itemCurrency }}{{ item.directly_price }}
Quantity
{{ quantity }}
{{ instockMsg }}
{{ limitText }}
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Sold by JD@CHINA
Ship to
{{ __("Ship to United States only") }}
Free shipping over 69
Genuine guarantee

Added to Cart

Keep Shopping

More to Consider

{{ item.brand_name }}

{{ item.item_name }}

{{ item.currency }}{{ item.market_price }}

{{ item.currency }}{{ item.unit_price }}

{{ item.currency }}{{ item.unit_price }}

Coupons

{{ coupon.coupon_name_new | formatCurrency }}
Clip Clipped Over
{{ getCouponDescStr(coupon) }}
{{ coupon.use_time_desc }}
Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

All rights reserved by Yami.

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Service Guarantee

Yami Cross-store Free Shipping over $69
Yami 30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69
Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)


Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Yami

Download the Yami App

Back Top

Recommended for You

About the brand

Jingdong book

为您推荐

Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review
{{ totalRating }} Write a review
  • {{i}} star

    {{i}} stars

    {{ parseInt(commentRatingList[i]) }}%

Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}
Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Review

Yami Yami

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

{{ commentDetails.content }}

Yami
Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ commentDetails.likes_count }} {{ commentDetails.likes_count }} {{ commentDetails.reply_count }} {{commentDetails.in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Yami Yami

{{ showTranslate(reply) }}Show Less

{{ strLimit(reply,800) }}Show more

Show Original

{{ reply.reply_content }}

{{ formatTime(reply.reply_in_dtm) }}

{{ reply.reply_likes_count }} {{ reply.reply_likes_count }} {{ reply.reply_reply_count }} {{reply.reply_in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Cancel

That’s all the comments so far!

Write a review
How would you rate this item?

Please add your comment.

  • A nice nickname will make your comments more popular!
  • The nickname in your account will be changed to the same as here.
Thanks for your review
Our community rely on great reviews like yours to find the best of Asia.

Report

If you find this content inappropriate and think it should be removed from the Yami.com site, let us know please.

Cancel

Are you sure to delete your review?

Cancel

You’ve Recently Viewed

About the brand

Jingdong book