|
Anyone can download and work with the latest versions of Office 2010 for free in this testing phase.
To download and see a video Click Here |
|
|
Written by Boyd Trimmell
|
|
Here is some sample code to parse out the City State and ZIP form a string.
Example usage:
? GetCity("Some Town, OK 73101") Some Town ? GetCity("Some Town OK 73101") Some Town
? GetState("Some Town, OK 73101") OK ? GetState("Some Town OK 73101") OK
? GetZIP("Some Town, OK 73101-0000") 73101-0000 ? GetZIP("Some Town, OK 73101") 73101
Following is the VBA code for the functions used above:
|
|
Read more...
|
|
|
Displaying specific dates |
|
Written by Boyd Trimmell
|
Displaying specific dates
To display specific dates, you can use the DateSerial() function to manipulate the day, month, and year portions of a date. For example, you can use the following expressions in the ControlSource property of a text box or in the Immediate window to return specific dates:
|
|
Read more...
|
|
|
|
|
|
|
Page 1 of 2 |