VBA: Add to a UserForm's Title with current text already as caption

Question

Good Evening,

I am having trouble with some VBA code. I need the add the Userform's Caption, with text already in place. This is for a application I'm writing which opens a file, and once the file has been opened, it will add the file name to the end of the UserForm's caption. For example:

Program Name: [File Name]

I wouldn't where to start really, which is why I'm here, but I think it might be something like

UserForm1.caption = "Program Name" + file.name

I don't know if this is really possible, but I would greatly appreciate some help

Cheers

It's not exact code, and I know that it's wrong because I haven't addressed the right controls in the code. — Josh F
– Josh F, Commented Dec 21, 2018 at 22:27

melp · Accepted Answer · 2018-12-21 21:56:45Z

1

Yes it' possible. I think a couple more steps needed

On open of application

logic example / not code:

Pub WriteFileName ()

Range("A:10")
End Sub

For the above, adaptable code example here : How to extract a file name from its path in vba

Then write another macro reading that cell range as string to your UserForm.Caption object i.e ="string" + range.("A10")

answered Dec 21, 2018 at 21:56

melp

644 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Josh F Over a year ago

I don't have 15 reputation yet, I'm new. But I will when I reach 15 rep. Thank you again.

Collectives™ on Stack Overflow

VBA: Add to a UserForm's Title with current text already as caption

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related