choosing rev table in ilogic

[bengee5454]

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?

[Sergio.D.Suárez]

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

[bengee5454]

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?