Inventor VBA - sync 'Prompted Entries' from Sheet:1 across all sheets.

[Nik_Barbour]

Hey all,

I'm unskillfully trying to crash my way through writing a VBA program for modifying Inventor drawing border info, and have managed through cannibalizing others programs to achieve 95% of what I wanted (ie the iproperties part).

The bit I have become stuck on is...Prompted Entries via VBA

I'd like to create a sync 'Prompted Entries' from sheet 1, across all sheets button.

Would anyone know the VBA to achieve this?

The 4 prompted entry fields are always....

In clearer words, I'd love some VBA code that could read the above 4 Prompted Entry values from Sheet:1 and then sync these values across multiple drawing sheets within one .idw file if more than one sheet was present.

Thanks in advance for any help anyone can give.

[Nik_Barbour]

Hey all,

I'm unskillfully trying to crash my way through writing a VBA program for modifying Inventor drawing border info, and have managed through cannibalizing others programs to achieve 95% of what I wanted (ie the iproperties part).

The bit I have become stuck on is...Prompted Entries via VBA

I'd like to create a sync 'Prompted Entries' from sheet 1, across all sheets button.

Would anyone know the VBA to achieve this?

The 4 prompted entry fields are always....

In clearer words, I'd love some VBA code that could read the above 4 Prompted Entry values from Sheet:1 and then sync these values across multiple drawing sheets within one .idw file if more than one sheet was present.

Thanks in advance for any help anyone can give.

[adam.nagy · Accepted solution]

Hi,

I'll try to answer this in a blog post:

http://adndevblog.typepad.com/manufacturing/2013/04/synchronize-prompted-entry-textbox-values-.html

I hope this helps.

Cheers,

[Nik_Barbour]

Thankyou - this works perfectly and is exactly what I needed.

Cheers