Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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
Feb 7, 2014
22
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
Replies continue below

Recommended for you

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