All,
I need to run a macro anytime a cell value changes, but the cell is a formula, not just a static value. I have tried the following code and it works fine if I manually enter a value in the target cell, but if I use a formula in the target cell it does not work. Is there a way to run the...
All,
I am using a "multi-page userform" to perform several static calculations in a file. The multi page user form always opens to the first sheet tab in the user form. Is there some way to open a multi page user form on a page (sheet tab) other than page 1?
Thanks
D23
All,
Is there a way to read the MS EXCEL Product ID number into a file. If I can read the ID number I can use it to limit use of a file to only computers I approve.
I have to distribute some files I wrote and need to prevent the files from being copied to other machines. If there is a...
All,
Is there a simple way to calculate motor size required when operating in an extended speed range for a squirrel cage type motor?
As an example assume the following:
I have a 380-volt, 50-hertz input supply to a ASD. For simplicity sake assume I can get 380 volts out of the drive.
At...
All,
I need to run a text disclaimer on start-up. Can I make a macro run when a file opens that would display text only? What I am looking for is a command similar to \0 in Lotus.
Thanks
D23
I am using a combo box from the “FORMS” toolbar. In the format control where you select the input range is there a way to automatically update the range?
I would like to write a series of “IF” statements that will determine the number of rows selected in the box. This selection will be...
All:
Lotus had a macro function named "window off." Is there a VBA code that does something like that? I'm am trying to freeze the window while a long macro runs. From memory the Lotus command(s) were:
{windowoff}
{windowon}
Thanks in advance
All:
I need to use a calculated friction loss in a spread sheet. This is a cool, clean fresh water application, so I assume Hazen-Williams will be reasonably accurate. I have looked, but cannot find a “C” factor for Driscopipe 1700 series. The formula I plan to use is:
F = K * L...
All:
I am looking at a possible application that will require a "water well type" submergible motor. I know Franklin and Pleuger are out there. There must be others. I'm looking for med voltage, 500+ HP. I need reliability. Any ideas or suggestions of who to check or who to avoid...
All:
My experience with slurry pumps is zero… I’m getting ready to search the net for crash course info. If anyone knows some good links I would appreciate it.
The current problem:
Within the next several days or weeks I have to review some slurry pumps that are operating in series due to...
All:
I have a few questions about VSD’s that is the result of reading other threads referring to motors needing to be VSD rated. I have not worked with drives in several years and realize that the technology has changed. Please correct me with my outdated assumptions.
I have seen several...
Hello All:
I need some help with a formula for specific heat. The Specific Heat of fresh water at 60 degree F is 1 Btu/lb F. Fresh water has a specific gravity of 1.00. Sea water has a specific gravity of 1.0257 and a specific heat of 0.94. Is there some calculation that will give me the...
