Loading
Everything HP200LX: Knowledge, Products, Service

 Archives
9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Links
Most useful, up-to-date Web sites devoted to the HP 200LX

Downloads
Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

 
Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)


 

 

Privacy Policy

System Macro Automates Filling in Month Names

System Macro Automates Filling in Month Names

If you're adventurous, and want to explore the power of the HP Palmtops, this sidebar shows you how to create a System Macro that automates the process of filling in the names of the months. This is a handy macro, if you need to perform this kind of operation repeatedly. On the other hand, if you only need to do the operation one or two times, you can ignore the macro. It's clever but takes more time to key in and debug than it takes to type in the information.

/df{BackSp}.{Down}{Down}{Down}{Down} {Down}{Down}{Down}{Down}{Down}{Down} {Down}{Enter}1{Enter}32{Enter}{Enter} /rfd3{End}{Down}{Enter}{Copy}.{End}{Down} {Enter}{Paste}/rs{BackSp}.{End}{Down} {Enter}xx{Esc}-00{Enter}lr{Enter} a{End}{Up}/rs{BackSp}.{End}{Down}{Enter} x{Esc} {Enter}lr{Enter}a{End}{Up}

The System Macro issues a series of 1-2-3 commands. It could almost be a 1-2-3 macro except that it uses the copy and paste command that are peculiar to the HP Palmtops. Copy and Paste can't be incorporated in a 1-2-3 macro. On the HP 95LX substitute {CtrlF2} and {Ctrl-F4} for {Copy} and {Paste}.

The macro starts with the Data Fill command. It creates a range of 12 cells and fills the range with numbers that Start with 1 and Increase by 32. The macro Formats the Range with Date 3 formatting. This produces fields that look like Jan-00, Feb-00, etc. Next, the range is Copied and Pasted back onto itself. This converts the fields to pure text, devoid of any numbers. The macro then uses the Range Search command to look for "-00" and Replaces All occurrences of this with nothing. Finally, it does another search and replace operation, looking for spaces and replacing them with nothing.

The extra commands in the macro allow month names to begin in any cell of the worksheet. If you need to put the names in a row instead of a column, you can use the (MENU) Range Transpose command.

iPhone Life magazine


Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

 
We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.
 

Copyright 2010 Thaddeus Computing Inc