Computing.Net > Forums > Programming > Dynamic Ranges/Input Masks

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Dynamic Ranges/Input Masks

Reply to Message Icon

Name: Jose
Date: September 9, 2002 at 12:31:34 Pacific
OS: Win NT
CPU/Ram: 1.2 GHz
Comment:

Hello,

I have a column in a spreadsheet (excel) that is used to list a fleet of equipment. The column to its right lists out the unit rate for that piece of equipment. An example would be: "1436 - 3/4 Ton Truck" In the unit column and "$6.34" for the unit rate.I was wondering...

1) How do I create an input mask in VB so that it creates a four digit unit number, then a space, then a hyphon, and then another space, and then a number of spaces to put a unit description (probably a max of 40 characters).
2) How do I create VB code so that I can select the "equipment" column and the "unit rate" column so that it will include all the updated information that I put in...I think its a dynamic range but I'm not sure. I can do it for one column alone with the offset command but I am unsure how to accomplish this with two columns.



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Dynamic Ranges/Input Masks

buil dynamic range processor www.computing.net/answers/programming/buil-dynamic-range-processor/3877.html

Exzcel VBA dynamic range www.computing.net/answers/programming/exzcel-vba-dynamic-range/19754.html

sql password mask in access www.computing.net/answers/programming/sql-password-mask-in-access/1299.html