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