- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
choosing rev table in ilogic
hi. I produce drawings for 2 companies, therefore I have 2 title blocks. Up until recently the title blocks were very similar (just changing company logo), so I used a bit of ilogic and created a form to switch between the 2.
If Title_Block = "Company A" Then ActiveSheet.TitleBlock = "CompanyA" ElseIf Title_Block = "Company B" Then ActiveSheet.TitleBlock = "CompanyB" End If
However, Company B decided to revamp its title block. Among other changes, the revision history block was extended. So now i have 2 revision table styles.
Is there a way to extend my rule to include rev history blocks?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello, if you can increase the entry in title block, adding all the revisions, I suppose you could use something like the following
If Title_Block = "Company A" Then ActiveSheet.TitleBlock = "CompanyA" ElseIf Title_Block = "CompanyB Rev1" Then ActiveSheet.TitleBlock = "CompanyB_Rev1" ElseIf Title_Block = "CompanyB Rev2" Then ActiveSheet.TitleBlock = "CompanyB_Rev2" End If
regards
Please accept as solution and give likes if applicable.
I am attaching my Upwork profile for specific queries.
Sergio Daniel Suarez
Mechanical Designer
| Upwork Profile | LinkedIn
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
thanks, but isn't this just expanding the choice of title block? I want to assign a rev history style to the title block.
what i really want is something like this (i have no idea of the code! - I have completely made it up!)
If Title_Block = "Company A" Then ActiveSheet.TitleBlock = "CompanyA"
ActiveSheet.RevisionHistory = "RevCompanyA" ElseIf Title_Block = "Company B" Then ActiveSheet.TitleBlock = "CompanyB" ActiveSheet.RevisionHistory = "RevCompanyB"
End If
is something like this possible?