Search results for query: *

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...

Luis Yes, FreeWheel fixed my problem and added some nice features. Glad it works for you too! Have a great day! Scott

Microsoft and Logitech's solutions do not work... However I found a guy who had the same trouble and wrote a great program to fix this type of problem and add some nice wheel features... go here... http://www.geocities.com/SiliconValley/2060/freewheel.html Have a great day! Scott

Joerd On another board I also found... AppActivate ("Microsoft Excel") This keeps the userform visible and sets focus to the named app Thanks for the input. Have a great day! Scott

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...

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...

Lindsbm There are tons of files out there on every subject... The question really is what subject are you looking for? You want to make them push button... Excel macros and VBA can accomplish anything you can imagine Spreadsheet data can be used to create ACAD drawings... there are lots of...

Mutt is right... just thought I'd give you a example to help... Dim rngLegacyBook as Range Set rngLegacyBook = Workbook("My Legacy Workbook").Worksheets("Sheet1").Range("A1") After the Set statement is executed, you can refer to the Range object simply as...

Trainguy I did a little tinkering... The results I had from the previous example was: 1) Numeric data did not clear the formatting 2) alpha charcters did. I think I found a solution for you with a small change. set up conditional formatting like this... if (cell value is) (equal to)...

WOW,lots of replys... thanks for the interest and help!!! gerhardf (Electrical) I didn't change the system date style or seperator because this would be a global change. joerd (Chemical) unfortunately the F2/enter had no effect Flareman (Petroleum) I did try the custom dates and it does work...

Well boys... After trying many peoples solutions and much frustration... I just wrote somthing quick and dirty... Thought I'd put it up in case anyone else has similar trouble. not pretty... but it does the job.. Sub ConvertDate() Application.ScreenUpdating = False Dim intCount As Integer...

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...

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...

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

Roy John Walkenbach has the answer you need... it saved me too. http://j-walk.com/ss/excel/usertips/tip042.htm I haven't tried to use "record macro" while doing this... might be worth a try? Scott

TG I have done something similar with conditional formating. set up conditional formatting like this... if (cell value is) (less than or equal to) ("") ( ) = the input box excel will change the "" into ="""" Hope this helps... Have a great day! Scott

John Check out John Walkers web site or books... that guy know every thing about excel!!! This link takes you to graphics in headers and footers. http://j-walk.com/ss/excel/usertips/tip014.htm Have a great day! Scott