First of all, I would like to ask why you want to transition your code from an iLogic rule, where this type of task is much simpler, to a VBA macro, where doing these things will be more complicated and will require a lot more code? If the reason is just so you can run the code from a macro button in your ribbon, then I would suggest only using the VBA macro to run your iLogic rule, and leaving your iLogic rule alone. But that's up to you.
I assume you are referring to the quoted word "back" in your original line of code, and that word being a name that you have assigned to a Face object in your sheet metal part model. Once again, finding those 'named' entities is much simpler to do using iLogic API code, but is much more complex, and will require a lot more code to do in a VBA macro. In order to specify that named face (the actual Face object, not just its name) in the Inventor API method I mentioned, you will need to find and get that named Face object first, so that you can supply that to the method.
In an iLogic rule, we could have used the following line of code to get that named Face in the part, from the drawing:
Dim oBackFace As Face = iLogicVb.Automation.GetNamedEntities(ThisDrawing.ModelDocument).TryGetEntity("back")
But since we can't use iLogic API code in a VBA macro, we will have to do it the older, and longer way. First, you will need to get a reference to the 'model' document that the views in your drawing are referencing. Then use its Document.AttributeManager property to get its actual AttributeManager object. Then, use its AttributeManager.FindObjects method.
Something similar to this:
Dim oDrawingDoc As DrawingDocument
Set oDrawingDoc = ThisApplication.ActiveDocument
Dim oModelDoc As Document
Set oModelDoc = oDrawingDoc.ReferencedDocuments.Item(1)
Dim oFoundObjs As Inventor.ObjectCollection
Set oFoundObjs = oModelDoc.AttributeManager.FindObjects("iLogicEntityNameSet", "iLogicEntityName", "back")
Dim oBackFace As Face
Set oBackFace = oFoundObjs.Item(1)
Then you can provide that oBackFace variable to the Sheet.CreateGeometryIntent method.
Wesley Crihfield

(Not an Autodesk Employee)