Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ByDesign
  • Content: Threads
  • Order by date
  1. ByDesign

    AC conductors perpendicular to DC conductors

    All, Good engineering practices for routing AC and DC conductors in seperate raceways and where they cross they should cross at 90 degrees to each other. I've been doing this for years and now I have to provide either code or good engineering practices guide that "Proves" that AC and DC...
  2. ByDesign

    Shift focus from a userform to excel

    Hello How can I shift focus from a visible userform to the excel sheet? Currently, the last statement in my procedure is... Sheets("MySheet").Range("B93").Activate The cell selector is put in the correct place, however the userform still has focus... therefore you must...
  3. ByDesign

    Application.OnKey(Key, Procedure) "Hot Keys"

    This is a great method... but of course I ran into some trouble. Application.OnKey(Key, Procedure) sets up hotkeys, for example if you would like "Shift & Cntl & F" to run a sub you would code... Application.OnKey "+^{k}, "MySub" I'm using this to show and hide a form...
  4. ByDesign

    Convert European to US date format

    Hello... TIA I have a spreadsheet developed on a european (German) version of excel/windows. The date columns are formatted for date "14-Mar-98", however they still are displayed as "14.03.03" and idea on a way to convert this? I've found lots of date solutions... but not...
  5. ByDesign

    Trick a function to perform an action?

    Hello Functions are designed only to return values... but I'm looking for a work around... I want to create a user defined function that when evaluated to 0 the row is hidden (the row the function is in). Perhaps this is a losing battle... ANY IDEAS? Thanks for the help!!! Have a great...
  6. ByDesign

    VBE and the mouse wheel

    Hello Does anyone know how to get the mousewheel to scroll in the VBE? The MS knowlege base says to update the mouse driver... I have the latest... What am I missing? Thanks for the help!!! Have a great day! Scott

Part and Inventory Search