Keyboard shortcuts for the Visual Basic Editor

The Visual Basic Editor (VBE) is the development environment in the MS Office applications. Fortunately, there are a number of keyboard shortcuts that you can use to work more efficiently while entering, viewing, and editing code.

Keyboard Shortcouts :

General
Alt + F11	This toggles switch displays the VBE from the application window and vice versa.
Ctrl + G	Displays Immediate window.
Ctrl + F	Opens the Find dialog box.
F3	Find Next.
Shift + F3	Find Previous.
Ctrl + H	Opens the Replace dialog box.
Ctrl + Z	Cancels the last keyboard stroke or the last mouse operation (when possible.)
F5	Runs the current procedure or continues execution after pausing.
Ctrl + Break	Halts a procedure.
Shift + F5	Terminates a procedure and resets all variables to their default values.
Shift + F10	Displays the active window’s shortcut menu.
Ctrl + R	Opens the Project Explorer.
F4	Opens the Properties window.
F2	Opens the Object Browser.
F1	Opens VBA Help.
F7	Gives focus to the open module window.
Code module
Ctrl + Down Arrow	Select next procedure.
Ctrl + Up Arrow	Select previous procedure.
Ctrl + Page Down	Shift one screen down.
Ctrl + Page Up	Shift one screen up.
Ctrl + Shift + F2	Go to last position.
Ctrl + Home	Go to beginning of module. (Also in the Immediate window.)
Ctrl + End	Go to end of module. (Also in the Immediate window.)
Ctrl + Right Arrow	Move one word to the right.
Ctrl + Left Arrow	Move one word to the left.
End	Move to the end of the line.
Home	Move to the beginning of the line.
Ctrl + Y	Delete current line.
Ctrl + Delete	Delete to end of word.
Ctrl + Shift + F9	Clear all breakpoints.
Project Explorer
F7Shift + Enter	Open the selected file’s module.
Home	Select the first file in the list.
End	Select the last file in the list.
Right arrow	Expands a sublist.
Left arrow	Collapses a sublist.
Up arrow	Moves up the list one item at a time.
Down arrow	Moves down the list one item at a time.

[via]

Popularity: 100%

Wordpress Auto Blogging Plugin – WP Robot

Today i found new wordpress plugin “WP-Robot”, this wp-plugin Automatically post Youtube Videos, Amazon Products, eBay auctions, Clickbank ads and much more to your blog without lifting a finger.

WP Robot Features:

This is a quick overview of all features of the WP Robot core version, which can be extended by adding aditional modules.

• Create posts related to your weblog’s topic. You can create posts for basically any topic you can think of. I have yet to discover a niche there is no content for on the websites WP Robot pulls content from.
• Create posts for many keywords at the same time.You can have 20 active keywords in the basic version and 50 keywords in the advanced of WP Robot simultaneously. The elite version even allows an unlimited amount of keywords.
• Add created posts to any category of your Wordpress weblog. You can choose a different category for each keyword you create.
• Custom time intervals between posts. You define the pace in which new content is added to your site by specifying a custom time interval for every keyword. You could for example add new posts for the keyword “ipods” every 2 hours or every 3 days (etc).
• Extend WP Robot’s functionality with new modules. Currently there are 7 different modules available and more will be released soon!
• Control exactly what content is created. By setting probabilities for every module or disabling modules for certain keywords you have full control over what WP Robot does.
• Creates tags for every post. Tags are one of the many powerful features of Wordpress. That’s why WP Robot will add several related tags for each post it creates.
• Bulk Add Keywords. Use the new bulk add keywords feature to set up a new autoblog even quicker than before.
• Many customizable options. You can for example choose if new posts are immediatelly published or added as drafts and much more…
• Free Support via the WP Robot support forum.

WP Robot Demo:

If you want to try the plugin yourself feel free to download the demo version!

WP Robot Screenshots:

The screenshots of WP Robot on this page are meant to show you how to admin panel of WP Robot will look inside of your Wordpress weblog and what you can do with it.

Click here for screen shots.

Creating your first automatic post with WP Robot:

Nokia Codes – Nokia Mobile Code – Nokia Secret Code

Nokia Universal Codes
Code Description :
These Nokia codes will work on most Nokia Mobile Phones

(1) *3370# Activate Enhanced Full Rate Codec (EFR) – Your phone uses the best sound quality but talk time is reduced my approx. 5%

(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370#

(3) *#4720# Activate Half Rate Codec – Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.

(4) *#4720# Deactivate Half Rate Codec.

(5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type.

(6) *#9999# Phones software version if *#0000# does not work.

(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number).

(8) #pw+1234567890+1# Provider Lock Status. (use the “*” button to obtain the “p,w”and “+” symbols).

(9) #pw+1234567890+2# Network Lock Status. (use the “*” button to obtain the “p,w”and “+” symbols).

(10) #pw+1234567890+3# Country Lock Status. (use the “*” button to obtain the “p,w”and “+” symbols).

(11) #pw+1234567890+4# SIM Card Lock Status. (use the “*” button to obtain the “p,w” Go to Topand “+” symbols).

(12) *#147# (vodafone) this lets you know who called you last.

(13) *#1471# Last call (Only vodofone).

(14) *#21# Allows you to check the number that “All Calls” are diverted to

(15) *#2640# Displays security code in use.

(16) *#30# Lets you see the private number.

(17) *#43# Allows you to check the “Call Waiting” status of your phone.

(18) *#61# Allows you to check the number that “On No Reply” calls are diverted to.

(19) *#62# Allows you to check the number that “Divert If Unreachable (no service)” calls are diverted to.

(20) *#67# Allows you to check the number that “On Busy Calls” are diverted to.

(21) *#67705646# Removes operator logo on 3310 & 3330.

(22) *#73# Reset phone timers and game scores.

(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature “SIM Clock Stop

Allowed”, it means you will get the best standby time possible.

(24) *#7760# Manufactures code.

(25) *#7780# Restore factory settings.

(26) *#8110# Software version for the nokia 8110.

(27) *#92702689# Displays – 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair (0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. ( Favourite )

(28) *#94870345123456789# Deactivate the PWM-Mem.

(29) **21*number# Turn on “All Calls” diverting to the phone number entered.

(30) **61*number# Turn on “No Reply” diverting to the phone number entered.

(31) **67*number# Turn on “On Busy” diverting to the phone number entered.

(32) 12345 This is the default security code.

press and hold # Lets you switch between lines

NOKIA5110/5120/5130/5190

IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #

NOKIA3110

IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #

NOKIA 3330

*#06#
This will show your warranty details *#92702689#

*3370#
Basically increases the quality of calling sound, but decreases battery length.

#3370#
Deactivates the above

*#0000#
Shows your software version

*#746025625#

This shows if your phone will allow sim clock stoppage

*4370#
Half Rate Codec activation. It will automatically restart

#4370#
Half Rate Codec deactivation. It will automatically restart

Restore Factory Settings
To do this simply use this code *#7780#

Manufacturer Info
Date of Manufacturing *#3283#
*3001#12345# (TDMA phones only)

This will put your phone into programming mode, and you’ll be presented with the programming menu.
2) Select “NAM1″
3) Select “PSID/RSID”
4) Select “P/RSID 1″

Note: Any of the P/RSIDs will work
5) Select “System Type” and set it to Private
6) Select “PSID/RSID” and set it to 1
7) Select “Connected System ID”

Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don’t know yours, ask your local dealer for it.
 Select “Alpha Tag”
9) Enter a new tag, then press OK
10) Select “Operator Code (SOC)” and set it to 2050
11) Select “Country Code” and set it to 302 for Canada, and 310 for the US.
12) Power down the phone and power it back on again

ISDN Code
To check the ISDN number on your Nokia use this code *#92772689#

Popularity: 1%

SAE International to Create Vehicle Battery Standards

The new SAE Vehicle Battery Standards Committee will initially focus on standardizing battery performance and safety and will assure harmonization with other standards development in the U.S. and around the world.

To address the continued development of new and advanced battery technologies that will play a critical role as vehicle manufacturers increase the availability of hybrid-electric vehicles, SAE International is creating a new Vehicle Battery Standards Committee which will serve as a center for standardization.

"We, along with the Alliance of Automobile Manufacturers and the Association of International Automobile Manufacturers (AIAM), recognize the importance that batteries and battery technology play in the design and development of new vehicles," David L. Schutt, PhD, Chief Executive Officer, SAE International, said.

The new SAE Vehicle Battery Standards Committee will initially focus on standardizing battery performance and safety and will assure harmonization with other standards development in the U.S. and around the world.

SAE International is a global association of more than 121,000 engineers and related technical experts in the automotive, aerospace and commercial-vehicle industries. SAE International's core competencies are life-long learning and standards development. SAE International's charitable arm is the SAE Foundation, which supports many programs, including A World In Motion and the Collegiate Design Series.

Global Demand for Bioplastics to Reach 900,000 Metric Tons by 2013

In the next few years, Braskem and Dow Chemical each plan to open plants in Brazil that will produce polyethylene from sugar cane-based ethanol, while Solvay is expected to open a bio-based polyvinyl chloride facility.

Bioplastics, plastic resins that are biodegradable or derived from plant-based sources, will rise more than fourfold to 900,000 metric tons in 2013, valued at $2.6 billion, according to a new report from The Freedonia Group. The growth will be fueled by a number of factors, including consumer demand for more environmentally-sustainable products, the development of bio-based feedstocks for commodity plastic resins, and increasing restrictions on the use of nondegradable plastic products, particularly plastic bags.

Most important, however, will be the expected continuation of high crude oil and natural gas prices, which will allow bioplastics to become more cost-competitive with petroleum-based resins.

Non-biodegradable plant-based plastics will be the primary driver of bioplastics demand, posting extraordinary growth from a small 2008 base. In the next few years, Braskem and Dow Chemical each plan to open plants in Brazil that will produce polyethylene from sugar cane-based ethanol, while Solvay is expected to open a bio-based polyvinyl chloride facility.

Biodegradable plastics, such as starch-based resins, polylactic acid (PLA) and degradable polyesters, accounted for the vast majority (nearly 90%) of bioplastics demand in 2008. Double-digit gains are expected to continue going forward, fueled in part by the emergence on the commercial market of polyhydroxy-alkanoates (PHAs). PLA will also see strong advances in demand as new production capacity comes online.

Western Europe was the largest regional market for bioplastics in 2008, accounting for about 40% of world demand. Bioplastics sales in the region benefit from strong consumer demand for biodegradable and plant-based products, a regulatory environment that favors bioplastics over petroleum resins, and an extensive infrastructure for composting.

Going forward, however, demand will grow more rapidly in the Asia/Pacific region, which will surpass the West European market by 2013. Gains will be stimulated by strong demand in Japan, which has focused intently on the replacement of petroleum-based plastics. Other regions, such as Latin America and Eastern Europe, will see stellar gains in bioplastics demand from a very small 2008 base.