Message 1 of 7
Insunits and associates

Not applicable
06-19-2006
03:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I am very new to VBA, ie. I have yet to write any code.
Does anyone have any code that sets InsUnits, InsUnitsDefTarget and InsUnitsDefSource all to the same value, when one of the values is set manually ?
For example, say I wanted to set InsUnits to the value of 6, it would then automatically set the values of InsUnitsDefTarget and InsUnitsDefSource to 6 also.
I know I can set all these values manually, but what's the point if I can get the code to do it for me?
I presume that this code would be fairly simple to do, but I am just starting out on the road to learning VBA, and I think this would be a good starting point.
Any help would be greatly appreciated.
Does anyone have any code that sets InsUnits, InsUnitsDefTarget and InsUnitsDefSource all to the same value, when one of the values is set manually ?
For example, say I wanted to set InsUnits to the value of 6, it would then automatically set the values of InsUnitsDefTarget and InsUnitsDefSource to 6 also.
I know I can set all these values manually, but what's the point if I can get the code to do it for me?
I presume that this code would be fairly simple to do, but I am just starting out on the road to learning VBA, and I think this would be a good starting point.
Any help would be greatly appreciated.