Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

CATVBA - Product Description Field

Status
Not open for further replies.

djmjr

Aerospace
Joined
Feb 7, 2014
Messages
22
Location
US
Hi, I'm looking for some guidance in refining my vba.

It works like it is expected, however, I want to change a couple of things and am unsure as to where to go.

I want the stock size of the Desciption field to read like this: 2.5 x 3.0 x 10.0, instead of 2.50in x 3.00in x 10.00in.

I've kind of figured out how to change the display magnitude via tool options, but that changes it globally and would rather not go this route. I'd like to be able to dictate the magnitude that is displayed in this field.

Any help will be appreciated.

Thanks!!

Dennis

 
 http://files.engineering.com/getfile.aspx?folder=4516fd6d-33ad-41e8-9544-555a507b69e3&file=Current_Output_from_VBA_Formula.PNG
Replace ToString('T-RND') with ToString( 'T-RND'/1in)


Eric N.
indocti discant et ament meminisse periti
 
The one thing I didn't think of. Thank-you!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top