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
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.
Summary: I need technical help. I made a dynamic Range Processor in VC++. Its behaviour is the same as cooledit with: Output Gain: 0 dB Attack Time: 0 ms Release Time: 0 dB Level Detector: Input Gain: 0dB Atta...
Summary: I am trying to write code (newbie here) to allow me to process the 1st 500 rows of an excel spreadsheet and replace certain cell values using a dynamic raning scheme: Dim intCredit As Integer Dim s...
Summary: I am running a query which is basically, select * from table1 where Enter_your_password=table1.password; I want the text typed in the window that appears for the password paramater to be displayed wit...